S spk1009 New Member Apr 13, 2012 #1 Am I able to run a macro when the excel workbook is closed? I have a monthly file and don't want to touch the orginial, I want to make a copy of that file to use for my analysis. Thank you in advance.
Am I able to run a macro when the excel workbook is closed? I have a monthly file and don't want to touch the orginial, I want to make a copy of that file to use for my analysis. Thank you in advance.
F fred Member Apr 13, 2012 #2 I guess the answer is yes after you have saved the original file with a different name. Then you run your macro in the newly named file whilst leaving the original untouched (closed).
I guess the answer is yes after you have saved the original file with a different name. Then you run your macro in the newly named file whilst leaving the original untouched (closed).
