Macro to open new file refresh all pivot with external connection and clos the file

[tracku]

I have 15 reports which need to be updated using Excel.
Current manual procedure is
open file --> Click on "Refresh All" (Doing so will refresh all pivot table with external connection -OLAP) --> Close the file.
This needs to be done for each 15 files.
Can someone please help me with code for this procedure?

Thanks in advance..!!

 

[wigi]

Hello

Why don't you set the connection to update when opening the workbook?
That way, you don't need to do it onbeforehand using code.