How to launch excel spreadsheet and load xml file from cmd line?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Excel 2003 spreadsheet that has a form in it that has XML fields
in it.
I need to launch the spreadsheet from a command line and have it load the
XML file to fill out the fields.

If I simply use the spreadsheet name followed by the XML file name, the API
call getcommandline simply returns "excel /e "

I can't find any reference to Excel command line switched that might help me.
Any ideas?
 
This command line doesn' t work correctly, it tries to load everything on the
command line..
"D:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" "C:\Documents and
Settings\rickhan.TIRNANOGMV\My Documents\Visual Studio
Projects\MatTracPrint\Manifest8700.xls" /e"C:\Program Files\InfoPath Form
Templates\MatTrac\ReadyToProcess\Manifest1.xml"

If this commandline would only load the xls file once, then I would be OK,
since get commandline does retrieve the entire cmdline string. I can then
load the XML file to update the firlds.
 
Back
Top