Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Opening XLS file directly and getting params

All,

I am working on a .NET application sued to "index" our many (+300)
Excel 2000 reports. The users log in and get a list of reports that
they are allowed to run. When they click on the "link", the app starts
the appropriate spreadsheet.

We are current doing this by running:
Excel.exe "FILENAME" /e/PARAMETERS

As you can see above, we are sending params (in this case, a connect
string) into the spreadsheet (not my design, I inherited it...) and
using some API calls that were found here to read the command line.
This is working correctly,

However, one of our users is complaining that, if they run 5
spreadsheets at the same time, they get 5 different instances of Excel.
I've noticed that if I just "shell" out to the XLS file (and don't put
EXCEL.EXE in front of it), then I get multiple spreadsheets in the same
instance of Excel; however, I can not read the parameters.

I guess I have two questions:
1. Can I read the command line if I call the XLS?

2. Is there a way to call EXCEL.EXE and have it re-use any existing
instances of Excel (if it is already running)?

Thanks
Jason

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



All times are GMT +1. The time now is 02:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"