Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Excel RTD with DCOM -- "Class not registered" error

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
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
"Select method of Range class failed" Error Ayo Excel Discussion (Misc queries) 3 September 2nd 08 07:58 PM
What is an Excel "class not registered" error. weberts2 Excel Discussion (Misc queries) 3 July 19th 05 08:01 PM
Error Message "Select method of worksheet class failed" philc Excel Programming 5 May 4th 05 08:07 AM
VBA error 1004 "Select method of Range class failed" Matt J Excel Programming 6 July 3rd 04 10:05 PM
Error 1004, "select method of range class failed" paritoshmehta[_11_] Excel Programming 3 May 6th 04 10:09 PM


All times are GMT +1. The time now is 12:25 AM.

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

About Us

"It's about Microsoft Excel"