Hi,

I've been searching without success for a list of excel command line options.

E.g. create a shortcut to c:\my folder\my spreadsheet.xls

I'm sure there must be commands that I can put after this.

Specifically, I would like to create a shortcut for a few users so that the
spreadsheet opens on a particular worksheet.

Any thoughts? Does anybody know the location of a suitable guide to the
command line options?

Many thanks,

Tom.

I'm sure there must be commands that I can put after this.

There is no command line option to open a workbook to a specific sheet.
You'd probably have to put an auto open macro in the workbook to do that.

--
Jim
"mr tom" <mr-tom at mr-tom.co.uk.(donotspam) wrote in message
...
| Hi,
|
| I've been searching without success for a list of excel command line
options.
|
| E.g. create a shortcut to c:\my folder\my spreadsheet.xls
|
| I'm sure there must be commands that I can put after this.
|
| Specifically, I would like to create a shortcut for a few users so that
the
| spreadsheet opens on a particular worksheet.
|
| Any thoughts? Does anybody know the location of a suitable guide to the
| command line options?
|
| Many thanks,
|
| Tom.

That's a shame.

I wanted a setting specific to a few users, but looks like that's not an
option.

Thanks any way.

Tom.

"Jim Rech" wrote:

I'm sure there must be commands that I can put after this.

There is no command line option to open a workbook to a specific sheet.
You'd probably have to put an auto open macro in the workbook to do that.

--
Jim
"mr tom" <mr-tom at mr-tom.co.uk.(donotspam) wrote in message
...
| Hi,
|
| I've been searching without success for a list of excel command line
options.
|
| E.g. create a shortcut to c:\my folder\my spreadsheet.xls
|
| I'm sure there must be commands that I can put after this.
|
| Specifically, I would like to create a shortcut for a few users so that
the
| spreadsheet opens on a particular worksheet.
|
| Any thoughts? Does anybody know the location of a suitable guide to the
| command line options?
|
| Many thanks,
|
| Tom.

Yes - In XL2003 at least:

- Open Help.
- Search for 'Command Line Switches'
- Select 'Customize How Excel Starts' (first result)
- Expand 'Use startup switches when you start Excel' (third option)

Alternatively, not knowing your ultimate goal but since you're posting
in the programming NG I would assume you want to make VBA macros
available to your users, you may like to look into using an AddIn and
installing this on your users' machines.

If you have a workbook that you always need to be opened on the same
worksheet you could write a Workbook_Open event to always select the
same sheet on workbook open.

HTH


mr tom wrote:
Hi,

I've been searching without success for a list of excel command line options.

E.g. create a shortcut to c:\my folder\my spreadsheet.xls

I'm sure there must be commands that I can put after this.

Specifically, I would like to create a shortcut for a few users so that the
spreadsheet opens on a particular worksheet.

Any thoughts? Does anybody know the location of a suitable guide to the
command line options?

Many thanks,

Tom.