I have a excle file that I call a templete file with a macro attached. The macro when run copies & pastes data from another excel file that was downloaded from a dbf file. After the macro copies & pastes the data I need to save the templete file with a new name using "save as". What I need to do is that when I use the "save as" feature that saves the templete file as a NEW excel file with a different name. It will put the NEW excel file name in the macro, that way I'll be able to use the macro with the NEW file. I will need to run the macro to copy & paste additional downloaded data in the week to the NEW file. Can anyone give me a hand. (Hope everyone understood what I am trying to do).