Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have been trying to get my RTD server working across the network.
I've read the Microsoft article "How to use an Excel RTD server with DCOM" (http://support.microsoft.com/kb/q285888/) as well as countless postings here and elsewhere. The RTD functions work fine running on my local pc, if I use something like this: =RTD("MyRTD.Server","MyComputerName","DoSomething" ,"ABC") But once I move this to a remote computer, I get the dreaded "#N/A" error in Excel. I've followed all of the instructions in the article above, plus I tried using a strong name for my assembly, adding it to the GAC, etc. I should note that when checking the "dcomcnfg" log on the RTD client I see the error "Class not registered from computer MyComputerName when attempting to activate the server..." When I do a "regedit" and search for the GUID of my rtd server (on the server itself), it's there, so I have to think it is in fact registered. My Excel macro security settings, on both client and server, are set to low. And each pc can ping the other. If there are any thoughts as to what I may be missing, please let me know. Thanks, Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"Select method of Range class failed" Error | Excel Discussion (Misc queries) | |||
What is an Excel "class not registered" error. | Excel Discussion (Misc queries) | |||
Error Message "Select method of worksheet class failed" | Excel Programming | |||
VBA error 1004 "Select method of Range class failed" | Excel Programming | |||
Error 1004, "select method of range class failed" | Excel Programming |