Now do I open an excel spreadsheet with vbscript?



Thanl for your help!

"SAC" <someone@xxxxxx> wrote in message
news:%236bb0HsuJHA.4648@xxxxxx

> 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

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:

> Now do I open an excel spreadsheet with vbscript?
>
> Thanl for your help!
>
>

Thanks!!

"Pegasus [MVP]" <news@xxxxxx> wrote in message
news:OjCykSsuJHA.5380@xxxxxx

>
> "SAC" <someone@xxxxxx> wrote in message
> news:%236bb0HsuJHA.4648@xxxxxx

>> 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
>
>

Thanks you!
"Dave Patrick" <DSPatrick@xxxxxx> wrote in message
news:OwWUs1suJHA.5380@xxxxxx

> 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:

>> Now do I open an excel spreadsheet with vbscript?
>>
>> Thanl for your help!

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:

> Thanks you!