I have recorded a macro to save a excel file as PDF and then print that file. I saved this file in folder A which is a last week report. Now next week i am copying this file and pasting in folder B to create a last week report. When i am using the macro, its saving the file as PDF but in folder A not in folder B. Could anyone please help me on this one?