View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Erich Neuwirth Erich Neuwirth is offline
external usenet poster
 
Posts: 41
Default Creating remote objects

I know how to create a DCOM object on a remote server using CreateObject
in VBA.
To do so, the object has to be registered on the client machine.
Then it can be created by using its name, e.g.
CreateObject("Excel.Worksheet","remotemachine")

Some other MS tools (Visual FoxPro for example)
have a procedure
CreateObjectEx
which allows to use the CLSID
(the strange thing like "{98de59a0-d175-11cd-a7bd-00006b827d94}")
instead of a name to create the remote object without a registry entry
on the local client machine.

Does anybody have a way of doing this in VBA?
The convenience is that then it is possible to install
a client in an Excel Addin accessing a remote server
without the need of running an installation program with
Administrator rights on the client.