|
 |  |  |  |  |  |  |
| Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks. |
| |||||||
 |
| |
04-11-2009
| #1 (permalink) |
| | Open Excell Spreadsheet Now do I open an excel spreadsheet with vbscript? Thanl for your help! |
My System Specs |
|
04-11-2009
| #2 (permalink) |
| | Re: Open Excell Spreadsheet "SAC" <someone@xxxxxx> wrote in message news:%236bb0HsuJHA.4648@xxxxxx Quote: > Now do I open an excel spreadsheet with vbscript? > > Thanl for your help! a large number of useful VB Script examples, e.g. this one: How Can I Save a Single Excel Worksheet to a CSV File? https://www.microsoft.com/technet/sc...5/hey0322.mspx |
| My System Specs |
|
04-11-2009
| #3 (permalink) |
| | Re: Open Excell Spreadsheet Air code but this should do it. Option Explicit Dim filePath1, oExcel filePath1 = "c:\Test1.xls" Set oExcel = CreateObject("Excel.Application") oExcel.Workbooks.Open(filepath1) 'do some stuff oExcel.Close(True, filePath1) oExcel.Quit Set oExcel = Nothing -- Regards, Dave Patrick ....Please no email replies - reply in newsgroup. Microsoft Certified Professional Microsoft MVP [Windows] http://www.microsoft.com/protect "SAC" wrote: Quote: > Now do I open an excel spreadsheet with vbscript? > > Thanl for your help! > > |
| My System Specs |
|
04-11-2009
| #4 (permalink) |
| | Re: Open Excell Spreadsheet Thanks!! "Pegasus [MVP]" <news@xxxxxx> wrote in message news:OjCykSsuJHA.5380@xxxxxx Quote: > > "SAC" <someone@xxxxxx> wrote in message > news:%236bb0HsuJHA.4648@xxxxxx Quote: >> Now do I open an excel spreadsheet with vbscript? >> >> Thanl for your help! > I strongly recommend you download the whole Scripting Guy help file. It > has a large number of useful VB Script examples, e.g. this one: > How Can I Save a Single Excel Worksheet to a CSV File? > > https://www.microsoft.com/technet/sc...5/hey0322.mspx > > |
| My System Specs |
|
04-11-2009
| #5 (permalink) |
| | Re: Open Excell Spreadsheet Thanks you! "Dave Patrick" <DSPatrick@xxxxxx> wrote in message news:OwWUs1suJHA.5380@xxxxxx Quote: > Air code but this should do it. > > Option Explicit > Dim filePath1, oExcel > > filePath1 = "c:\Test1.xls" > Set oExcel = CreateObject("Excel.Application") > oExcel.Workbooks.Open(filepath1) > 'do some stuff oExcel.Close(True, filePath1) > oExcel.Quit > Set oExcel = Nothing > > > > -- > > Regards, > > Dave Patrick ....Please no email replies - reply in newsgroup. > Microsoft Certified Professional > Microsoft MVP [Windows] > http://www.microsoft.com/protect > > > "SAC" wrote: Quote: >> Now do I open an excel spreadsheet with vbscript? >> >> Thanl for your help! |
| My System Specs |
|
04-11-2009
| #6 (permalink) |
| | Re: Open Excell Spreadsheet You're welcome. -- Regards, Dave Patrick ....Please no email replies - reply in newsgroup. Microsoft Certified Professional Microsoft MVP [Windows] http://www.microsoft.com/protect "SAC" wrote: Quote: > Thanks you! |
| My System Specs |
|
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Forum | |||
| excell 2007 | Microsoft Office | |||
| script to add 2000users from excell in 2008server | VB Script | |||
| Excell-Navigating using arrows | Vista General | |||
| Excell File Won't Restore | Vista performance & maintenance | |||
| microsoft excell | Vista hardware & devices | |||
