You can use CreateObject to create an instance of Excel,
which has all the functionality you need:

set XL = CreateObject("excel.application")
XL.visible = True ' if you need to see what's happening
set wb= XL.workbooks.open("myfile.csv")
' etc etc
XL.Quit



Sam Raymond wrote:
I'm using a VBS script to generate a CSV file.
I'd like to tune up the script in such a way that it will format the output
so that it opens nicely in XL. To do so, I've recorded a macro for
formatting the data, but the problem is that the file gets re-written each
time I run the VBS script.

I'd like to know if I can write the code from the XL macro directly into the
VBS script. Anyone know how to do this?

In the past, I've been able to open an existing spreadsheet and run an
existing macro using a VBS script, but this is different, because the output
file is overwritten each time the data is generated, so I can't store a macro
inside the spreadsheet. I need to store the 'macro' inside the VBS code.

Thanks! Sam