GetObject {Resolved}

[thedude1972]

I have created a dll in VB 6.0. I am using the GetObject method to get the path of the excel file that called the dll. However, I have just realized that if there are two different excel files open, this will return the first file path that was opened, not necessarily the file that called the dll. Is there another method that I can use...like GetThisObject, or something similar?

Below is an example of what I am using.


Dim ExcelTest As Excel.Application

Set ExcelTest = GetObject(, "Excel.Application")


In addition, when I try to use this method in a simular method in Access 97, I get a "Run-Time Error '429': ActiveX component can't create object" error. However, this will work in Access 2000.

The code being used for the Access application is

Dim AccessTest As Access.Application

Set AccessTest = GetObject(, "Access.Application")


Any ideas??

Thanks!