ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do I access the MSNStockQuoteRefreshAll function in VBA code . (https://www.excelbanter.com/excel-programming/324618-how-do-i-access-msnstockquoterefreshall-function-vba-code.html)

MJB

How do I access the MSNStockQuoteRefreshAll function in VBA code .
 
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



All times are GMT +1. The time now is 12:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com