How do I access the MSNStockQuoteRefreshAll function in VBA code .

M

MJB

I want to write an Excel macro to refresh stock quotes that were generated by
the MSNStockQuote function. The Object Browser identifies a function in the
clsRTD class called MSNStockQuoteRefreshAll(). Perhaps I don't know how to
properly call the function - Call MSNStockQuoteRefreshAll - doesn't work. I
see no reference to this function in the Microsoft KnowledgeBase and only one
reference to it on the web (another person asking the same question I am). I
want to place the function in a sub routine that's on a timer
(Application.OnWait/OnTime) so the refresh takes place every half hour.

Any thoughts on this will be appreciated
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to display the merge function "url" of a picture? 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
non basic code in call stack 3
Prompt For Replace in Selection And More... 0
VSTO C# add in Outlook.Appointment error 0
How do I remove the top half of a block interval? 1
Can I still register a function in a DLL using ExecuteExcel4Macro REGISTER? 6
Use TODAY() function as the criteria in a SUMIF formula 1

Top