VishalMistry
10th June 2011, 08:57
Hi All,

I am using app_start to open Excel on client machines but every time this function is invoked, it starts a new instance of Excel. Is there any way to detect and utilize already running instance of Excel on client machine ?

Note:The instance of Excel may be started by user out of Ln.

Pl guide.

Vishal

george7a
10th June 2011, 11:53
1) Please post your code
2) What office version do you use?

VishalMistry
10th June 2011, 12:28
Hi,
following is the line in the script that invokes Excel and also passes on csv file as parameter:

app.id = app_start("excel.exe c:\tfacp2420m000.csv", "", "", "", "")

We use office version 2003 & 2007 on clients and it opens on both version, the only issue is I want to check if already any instance of Excel is running or not.

Vishal

george7a
10th June 2011, 13:37
I have found an answer that can be done in office 2003.. try it:
Select Tools|Options -> General (Tab) and uncheck "Ignore other applications"

VishalMistry
11th June 2011, 07:17
Hi,

I tried you suggestion but it still opens separate instance on every call to app_start. This option is available in Excel 2007 also.

Vishal