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

  • Thread starter Thread starter blupian
  • Start date Start date
B

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
 
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
 
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 :(
 
Back
Top