I'm creating a macro to save an Excel file under a few DIFFERENT names. The files are saved in the last directory used by Excel. This is not what I want. I would like the file to be saved in the same directory as the current file (the one I'm "saving as" a different name).

Anyone has a clue?

Thank you in advance.