LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc,pl.comp.lang.vbasic
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
unhide menu bar in excel - just disappeared Sean Setting up and Configuration of Excel 12 April 4th 23 10:19 AM
Open Excel 2003 from Windows Explorer pmpjr Excel Discussion (Misc queries) 9 September 11th 06 03:58 PM
convert pocket excel back to standard excel kevroyal Excel Discussion (Misc queries) 1 February 16th 06 11:35 AM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
Excel 2002 and 2000 co-install. Control Which Starts ? cnuk Excel Discussion (Misc queries) 2 January 17th 05 08:07 PM


All times are GMT +1. The time now is 02:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"