MrExcel Publishing
Your One Stop for Excel Tips & Solutions

What is the macro command to refresh data?


Posted by Keith on January 15, 2002 8:15 PM

I have a spreadsheet that contains a link to external data via a web query. The data is refreshed when I click on the refresh data button in the toolbar. However, I want to be able to run this command from my own custom button (as opposed to using the toolbar button). Does anyone know the macro command for this?


Posted by Bariloche on January 15, 2002 8:18 PM

Keith,

Have you tried recording the action in a new macro? Then use the relevant info in your event procedure.


enjoy