"Unable to get the RTD property of the worksheet function class"

[blupian]

Hi!

I'm succesfully bringing data from an RTD server to an Excel cell using the
formula:

=RTD("ontrade.quotes";"";"COMX";"GCQ9";"prevclose")

However when I try to use WorksheetFunction.RTD to bring the data to a VBA
macro I get an error message. This is what I write in the macro:

MsgBox WorksheetFunction.RTD("ontrade.quotes", vbNullString, "COMX", "GCQ9",
"lastvalidprevclose")

And this is the error message:

"Unable to get the RTD property of the worksheet function class "

What can the problem be?

I have previously asked the same question in an Excel forum without finding
an answer:

http://www.excelforum.com/excel-pro...the-worksheet-function-class.html#post2104299

 

[Allllen]

Some thoughts:

1. if you can make it work in an excel cell, i don't see why it wouldn't
work in your code

2. commas and semi-colons. not sure if that makes a difference. just an
idea.

3. why swap "prevclose" to "lastvalidprevclose" ?

4. try """" instead of the vbNullString

 

[blupian]

Hi!

1. Not me either

2. Should be commas in VBA and semicolon in Excel with my language settings

3. No reason really, both of them should work

4. Have already tried