call RTD from com automation add in

[QldRobbo1]

Hi,
I have made an RTD server as based on the following article

http://msdn.microsoft.com/en-us/libr...ffice.10).aspx

and it works perfectly if I call it directly from excel

Please Login or Register  to view this content.

returns the number and it updates perfectly every 2 seconds.

However, I want to call this from my com automation add-in.

When I call the RTD from com it runs and gets the number fine from the RTD server but then it DOES NOT UPDATE.

Please Login or Register  to view this content.

My add-in works fine as I have other functions which work perfectly.

How can I call the RTD function from an automation add-in and have it automatically update?!

Any help appreciated.

[Leith Ross]

Hello QldRobbo1,

Welcome to the Forum!

Your question isn't really related to this forum as this is for VBA (Visual Basic for Applications) programming. Your question concerns VB.Net and COM. COM objects can be accessed or called from VBA but that is about all. There is limited control of the interfaces like IDispatch and IUnkown in VBA and marshalling, well we can only wish. We probably have some members here who can help you, but that may take awhile, as people here aren't looking for answers to VB.Net questions.