Can you do an Excel Data Import using vbscript?

[realty205]

I was hoping that I could do an Excel Data Import utilizing vbscript. Does anyone know if this is possible? Anyone have a sample?

 

[PHV]

Do you know how to do it in Excel VBA ?
If not then use the Excel macro recorder doing the import manually.
Finally it's just a matter of executing the code with OLE automation from VBScript.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ShadowFox333]

Hello,
I wrote a script that opens a csv file, sets all the cell columns to auto fit, edits the cell formats of certain columns, (zip to 5 zeroes so the leading zeroes don't get dropped) and then writes the file out as an excel spreadsheet. Is that something that could fit into what you are trying to do?

Bob