A
andrzej.dmoch
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
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