Macro for updating webservice functions
I have a workbook that has stock data using a webservice function and I am updating it with Alt-Ctrl-F9. I am trying to create a macro that will perform the same function as Alt-Ctrl-F9, but I have no luck. I tried to record myself by clicking these buttons, I tried
Activeworkbook.RefreshAll
DoEvents
and i also tried
ActiveSheet.Calculate
So far I have had no luck ...
+3
source to share
1 answer
Use
Application.CalculateFull
or
Application.CalculateFullRebuild
The first one is the one used if you are recording a macro on click CTRL+ALT+F9. The latter is a more thorough version that rebuilds the computation tree. See CalculateFullRebuild and CalculateFull powered by MS for a complete history.
+4
source to share