rortiz77
asked on
Converting a .CSV format to a 97-2003 .XLS format
Is there a VB script where i can take a .csv file and convert it to a MS Excel 97-2003 .xls format? I want to automate the process of opening a .csv file in Excel, doing the save as, selecting "Microsoft Excel 97-Excel 2003 &5.0/95 Workbook (*.xls)" and saving. Is this possible?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hmmm...don't supposed you have another trick up your sleeve. The sever doesn't have MS-Excel installed so it can't find the needed files. I get error:
"ActiveX component Can't create object: 'Excel.Application'
Code: 800A01AD
Source: Microsoft VBScript runtime error"
"ActiveX component Can't create object: 'Excel.Application'
Code: 800A01AD
Source: Microsoft VBScript runtime error"
If you want to convert your file to Excel, you should have Excel installed - I cannot see any other way.
ASKER