Copy, edit and save workbook to same location as source data file, not macro file.

Having a fairly simple issue. Searching around isn't revealing the sort of short, simple solution I'm confident exists.

I have my macros loaded into a workbook that is opened in the background. (this is the way it has to be for reasons beyond my control)

I have a source data file. I need to make a copy of it, perform some macros to it, and then save that edited copy automatically back to the same folder the original file was opened from/located in. The copy is of course in a temp file, so then the save was dumping there. Then I tried the code below, but it seems to be saving to wherever the macro workbook is, not the original workbook. I presume there's either a variant of the 'ThisWorkbook.Path' command that I'm missing, or I need to log the original file location as a variable that is recalled later when saving, but I'm not savvy enough yet to know how to code that on my own. I'm lucky I understand that's a programming strategy at this point!

Thank you in advance.

Please Login or Register  to view this content.

As you see, I have it set so that after the copied file is saved, it will close, which takes the user back to the original untouched file.

Hi, Jasonhouse,

instead of

Please Login or Register  to view this content.

try

Please Login or Register  to view this content.

Ciao,
Holger