General information
Category:
Coding, syntax & commands
>Nick,
>
>>Maybe I should automate saving it as the correct version in excel
>
>That'd certainly be a way to do it, provided Excel is installed on the machine running the process. The ODBC driver doesn't require Excel to be installed.
Hi Dave
if I have
oExcel = CreateObject("Excel.Application")
oWorkbook = oExcel.Application.Workbooks.Open(lcFilename)
oWorkbook.SaveAs("j:\global\ss\correct.xls", 56) && xlExcel8
why do I get "Unable to get the SaveAs property of the workbook class.
Update it doesn't like the 56 so I need to find the correct filetype parameter.
2nd Update 39 is the value I want.
I hate automation :-(
Thanks
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only