Thanks in advance to everyone that helps out here.

My issue is I am trying to get a macro to import external data from an existing Excel file that changes. I've recorded the Macro to import external data to a pivot table but I need it to prompt which file to import from each time as this changes.

Here is the code so far and the file in this instance is Test Data. 

Please Login or Register  to view this content.