Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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.
Reply
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
Launch Program then load file Keyrookie Links and Linking in Excel 1 March 1st 10 11:45 PM
2007 Excel will not launch from file Barbara Excel Discussion (Misc queries) 2 July 31st 08 06:36 PM
How do I auto launch an excel file upon log in? Starion Excel Discussion (Misc queries) 1 April 24th 06 08:02 PM
Load DBF file into Excel on command line? prospects Excel Discussion (Misc queries) 0 January 30th 05 12:39 AM
launch any file type from excel macro arron laing Excel Programming 4 July 23rd 04 08:23 AM


All times are GMT +1. The time now is 01:16 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"