Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
screen goes black when creating or dragging drawing objects ... | Excel Discussion (Misc queries) | |||
Remote Filtering | Excel Discussion (Misc queries) | |||
why are the help files now remote? | Excel Discussion (Misc queries) | |||
Remote References | Excel Discussion (Misc queries) | |||
remote refrences | Excel Programming |