HOw to remove macros/query from saved sheets

[t16turbo]

hi there,

a macro I am working on goes through a query refresh procedure and saves the spreadsheet on each loop.
I need the saved spreadsheets to be without the queries and macro embedded.

is this possible?

thanks in advance,

 

[PHV]

Have a look at the PasteSpecial method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886