I've exported the results of a parametric query in an excel file (I've setup
the file and the spreadsheet)
Then I've built a macro that replace some words with others..then I've built
a pivot table and I've copied and paste it on another excel file .Of course
the above macro can't be attached to the excel file because it changes
everytime I update the query so it deletes itself .So I've had the idea of
export the results of the query in the excel file then close it and put the
macro I've built on the third excel file..
is it possible to execute a macro on a file that it's closed ??