View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Anand Nichkaode Anand Nichkaode is offline
external usenet poster
 
Posts: 53
Default 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