B
Bill
I have a function in Access that opens an Excel spreadsheet. That
spreadsheet uses the MSNStockQuote Add-In to retrieve and manipulate stock
quotes. I'm having difficulty getting it to refresh the quotes via code.
Using the object browser, I find a function MSNStockQuoteRefreshAll that I
invoke as follows.
Dim oStocks as Object
Workbooks.Open FileName:="c:\pathtofile\stocks..xls"
Sheets("Lookup").Select
Set oStocks = CreateObject("MSNStockQuote")
Call oStocks.clsRTD.MSNStockQuoteRefreshAll
Set oStocks = Nothing
The stocks aren't updated. I'm guessing I'm not waiting for the update to
finish. I can't find documentation to tell me what property indicates that
has occurred so I can wait for it. Everything else is working great.
Any help would be appreciated. Thanks in advance.
spreadsheet uses the MSNStockQuote Add-In to retrieve and manipulate stock
quotes. I'm having difficulty getting it to refresh the quotes via code.
Using the object browser, I find a function MSNStockQuoteRefreshAll that I
invoke as follows.
Dim oStocks as Object
Workbooks.Open FileName:="c:\pathtofile\stocks..xls"
Sheets("Lookup").Select
Set oStocks = CreateObject("MSNStockQuote")
Call oStocks.clsRTD.MSNStockQuoteRefreshAll
Set oStocks = Nothing
The stocks aren't updated. I'm guessing I'm not waiting for the update to
finish. I can't find documentation to tell me what property indicates that
has occurred so I can wait for it. Everything else is working great.
Any help would be appreciated. Thanks in advance.