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

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

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