ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to launch excel spreadsheet and load xml file from cmd line? (https://www.excelbanter.com/excel-programming/307696-how-launch-excel-spreadsheet-load-xml-file-cmd-line.html)

RickH

How to launch excel spreadsheet and load xml file from cmd line?
 
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?

RickH

How to launch excel spreadsheet and load xml file from cmd line?
 
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.


All times are GMT +1. The time now is 05:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com