LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
screen goes black when creating or dragging drawing objects ... Tori Dunbar Excel Discussion (Misc queries) 1 February 4th 08 04:19 PM
Remote Filtering [email protected] Excel Discussion (Misc queries) 1 April 6th 06 01:52 AM
why are the help files now remote? Sean Excel Discussion (Misc queries) 2 April 1st 06 10:11 PM
Remote References Lfp Excel Discussion (Misc queries) 0 March 29th 06 05:46 AM
remote refrences ian Excel Programming 0 October 3rd 03 12:21 PM


All times are GMT +1. The time now is 03:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"