![]() |
Executable for converting excel XML to XLS
Hi All,
My goal is to have a simple command line converter (executable) for converting excel 2003 XML files to XLS files. Something like: xml2xls.exe src.xml dest.xls I know such thing can be written in VB but I'm not an expert in this area. My knowledge is too short to provide the proper headers and to compile it. So please help! Of course the lines of VB code are something like: ChDir "M:\Projects\_Reports\2006\10" ActiveWorkbook.SaveAs Filename:= _ "M:\report.xls", FileFormat:= _ xlExcel9795, Password:="", WriteResPassword:="", ReadOnlyRecommended:= _ False, CreateBackup:=False I miss the information: (1) How to read the activeWorkbook from XML (2) How to provide command line parameters instead of constant above (3) How to compile it into EXE Regards, Andrzej |
All times are GMT +1. The time now is 09:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com