MSN Money Central macro timing question

[tmerritt]

I just recorded a quick macro to make some formating changes and refresh a feed I have set up from MSN Money Central. As a part of this I am copying values coming in from the feed and pasting them into a log I am keeping of historical values.

The problem I am having is when I run the macro, it copies the data in the cells BEFORE the values have been updated to the new values. the data does eventually update (1-3 seconds AFTER it had been copied). Essentially the macro is running so fast that it doesnt give the connection time to update itself before it finishes. for the record, I DID record it so that the refresh of values happens before the copy, so i know that is not the problem!

is there a way to force excel to pause as a part of the macro, or to ensure that the values have changed before copying them?

Thanks for the help!

 

[John_w]

Are you retrieving the data with a web query? If so, try BackgroundQuery:=False on the query's Refresh method.

 

[tmerritt]

I am getting the data using the default MSN Money Central tool that comes stock in excel. all i do to update it is hit the "refresh all" button under the data tab. with my MINIMAL knowledge of VBA i believe the coding for this is ' ActiveWorkbook.RefreshAll '

 

[John_w]

Which tool are you referring to? I can't really help because I'm not aware of any MSN Money Central tool that comes with Excel. The only ones I know about are the stock quote template and add-in available from http://www.vertex42.com/ExcelTemplates/excel-stock-quotes.html.