Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Command line
Hi,
I have an XLA which I start with the following way. Exce <Name & Path of XLA /e<Name & path of the template /e prevents Excel from showing the startup scree and opening blank worksheet. The XLA receives the command line parameter and retrieves the Template name and path and opens it and works on it. The problem is when this <Name & path of the template has spaces in it then Excel shows error below message. <part of the Name & path of the template till the first space could not be found. Check the spelling of the filename, and verify that the file location is correct. If you are trying to open the file from your list of most recently used file on the File menu, make sure that the file has not been renamed, moved or deleted. Any help on this appreciated. Thanks, Anand |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Command line
In general, use double quotes:
"c:\program files\microsoft office\office11\excel" etc. -- Gary''s Student - gsnu200844 "Anand Nichkaode" wrote: Hi, I have an XLA which I start with the following way. Exce <Name & Path of XLA /e<Name & path of the template /e prevents Excel from showing the startup scree and opening blank worksheet. The XLA receives the command line parameter and retrieves the Template name and path and opens it and works on it. The problem is when this <Name & path of the template has spaces in it then Excel shows error below message. <part of the Name & path of the template till the first space could not be found. Check the spelling of the filename, and verify that the file location is correct. If you are trying to open the file from your list of most recently used file on the File menu, make sure that the file has not been renamed, moved or deleted. Any help on this appreciated. Thanks, Anand |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Command line
Thanks for the response.
I missed to mention in my last post that putting things in dobule quotes does not help. -Thx Anand "Gary''s Student" wrote: In general, use double quotes: "c:\program files\microsoft office\office11\excel" etc. -- Gary''s Student - gsnu200844 "Anand Nichkaode" wrote: Hi, I have an XLA which I start with the following way. Exce <Name & Path of XLA /e<Name & path of the template /e prevents Excel from showing the startup scree and opening blank worksheet. The XLA receives the command line parameter and retrieves the Template name and path and opens it and works on it. The problem is when this <Name & path of the template has spaces in it then Excel shows error below message. <part of the Name & path of the template till the first space could not be found. Check the spelling of the filename, and verify that the file location is correct. If you are trying to open the file from your list of most recently used file on the File menu, make sure that the file has not been renamed, moved or deleted. Any help on this appreciated. Thanks, Anand |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Are there command line parameters for Excel? | Excel Discussion (Misc queries) | |||
Print an excel file from command line or "cron" type command ??? | Excel Programming | |||
How to Get Excel Command Line Programmatically | Excel Programming | |||
Excel command line | Excel Programming | |||
Run Excel Macro from Command Line | Excel Programming |