Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc,pl.comp.lang.vbasic
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
convert pocket excel back to standard excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |