how automate the Refresh All

[andrea_illo]

hello all
I come back :P
This is my problem this time.
I have excel 2010 and powerpivot 11.0.3000.0

This is what microsoft write:

To refresh data for a single table or all tables in a workbook

• In the PowerPivot window, click the Home tab, and in the Get External Data group, click Refresh, and then click Refresh or Refresh All.

I would need to automate the Refresh All in a macro (VBA), how can I do?



sorry for my english and thanks to all
Andrea

 

[andrea_illo]

...no one has an answer?