We are doing a very interesting project using ActiveX to run remote agents, and we have run into a simple but difficult problem, illustrated below using Excel.

I would be very grateful if you have any ideas that could help us resolve our difficulty using ActiveX to create an object remotely. Thanks, Dan King

__________________________________________________

'Excel object created locally - works OK

Dim x as Object
Set x = CreateObject("Excel.Application")
__________________________________________________

'Excel object created locally, identifying server name - works OK

Dim x as Object
Set x = CreateObject("Excel.Application", "LocalHost")
__________________________________________________

'Excel object created remotedly - produces error:
'ActiveX unable to create object

Dim x as Object
Set x = CreateObject("Excel.Application", "MyServer")
__________________________________________________

Any idea why an object cannot be created on "MyServer"?