I am developing an ASP app that needs to retrieve an already open instance of Excel, grab it, do what it has to do and then that's pretty much it.

I 1st tried to use Server.GetObject in ASP, but I received the following error:
Microsoft VBScript runtime (0x800A01B6)
Object doesn't support this property or method: 'Server.GetObject'

So then I proceeded to make an ActiveX DLL that would do this for me, and all I would have to do is create an instance of the DLL in my ASP page and it should work right??? Well the DLL worked as planned when I ran it in a VB6 app/project group, but when I ran it in an ASP script, the GetObject in the DLL didn't work.

My DLL tries to get an instance of Excel, and if it doesn't exist, it creates a new one. So therefore I know that when the script is ran, for some reason, the GetObject in the DLL is not working.

Is there something that I need to do on my machine or in my wwwroot directory, or am I doing something wrong?

Please Help...