macro to refresh webservice functions

Question

I have a workbook that has stock data pulled in using the webservice function and I refresh it using Alt-Ctrl-F9. I am trying to create a macro that will do the same function as Alt-Ctrl-F9 but I haven't had any luck. I have tried recording myself pressing those buttons, I've tried

Activeworkbook.RefreshAll  
DoEvents

and I have also tried

ActiveSheet.Calculate

So far, I am having no luck...

Answer 1

Use

Application.CalculateFull

or

Application.CalculateFullRebuild

The former is the one that is used if you record a macro while hitting CTRL+ALT+F9. The latter is a more thorough version which rebuilds the calculation tree. See CalculateFullRebuild and CalculateFull at MS support for the full story.