Get unique identifier from Desktop

[MacroAlan]

I NEED TO EXPLAIN WHAT I am doing before I know the right words to ask my question.

In our application in Access VBA, we do a bunch of stuff preparing the data; then open an Excel template and put in some of the data. Next my program calls a macro within the Excel. After it does its thing, Access takes back control and I do more stuff.

There may be multiple instances of Excel open/or opened. I think it is a call to the API to get the unique identifier for each instance of Excel when I start it.

Can anybody tell me what I need to call in the API?

Thanks


Alan

 

[PHV]

then open an Excel template
What is the access code doing that ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[MacroAlan]

Looks like something got cut off -- I was logged into server at office.

Since I am taking back control in Access from Excel and grabbing it again, I want to be sure that I am grabbing the correct instance of Excel each time. Is there a way to capture the Instance ID at the beginning of my procedure?


Alan

 

[SkipVought]

Yes, Set a Workbook Object when you open the workbook and reference that object. Make sure that the SCOPE of that object is defined appropriately.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}