The server threw an exception error in Windows 7 Excel to CSV Vbs -
i running script below in command line: excel-to-csv.vbs test.xlsx test.csv
if wscript.arguments.count < 2 wscript.echo "please specify source , destination files. usage: exceltocsv <xls/xlsx source file> <csv destination file>" wscript.quit end if csv_format = 6 set objfso = createobject("scripting.filesystemobject") src_file = objfso.getabsolutepathname(wscript.arguments.item(0)) dest_file = objfso.getabsolutepathname(wscript.arguments.item(1)) dim oexcel set oexcel = createobject("excel.application") dim obook set obook = oexcel.workbooks.open(src_file) obook.saveas dest_file, csv_format obook.close false oexcel.quit
i have excel 2007 installed on windows 7 home - 64 bit pc.
the script converts .xlsx/.xls file .csv file.
when run script, error message seen in image below, cannot understand why comes out. idea how fix this?
line: 17 char: 1 error:the server threw exception code: 80010105 source: (null)
here screenshot of error:
Comments
Post a Comment