ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Executable for converting excel XML to XLS (https://www.excelbanter.com/excel-discussion-misc-queries/77183-executable-converting-excel-xml-xls.html)

[email protected]

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