How can I access VBA on a remote machine?

[Thomas Fischer]

Hello,

I would like to retrieve and access a scripting object from
a remote host. Something like this:

Dim ExApp as object
ExApp = GetObject(, "192.168.0.100\\Excel.Application")

My objective is to balance the load between two intensively-
working applications between two machines. Is there a mechanism
that allows this?

Thanks a lot!
Tom

 

[Lance Wynn]

You can create an ActiveX DLL that creates the excel application, and does
whatever magic it needs to do, and then register it as a COM+ component on
both server machines. You can then access your Excel Apps vicariously
through COM+



Hello,

I would like to retrieve and access a scripting object from
a remote host. Something like this:

Dim ExApp as object
ExApp = GetObject(, "192.168.0.100\\Excel.Application")

My objective is to balance the load between two intensively-
working applications between two machines. Is there a mechanism
that allows this?

Thanks a lot!
Tom

 

[Thomas Fischer]

Thanks a lot for your help! I will give it a try...