Move the existing (opened) workbook to a new folder location

Hello,

Is it possible to move an open workbook to a new folder location ?

I am currently using

Please Login or Register  to view this content.

However, with that there exists two copies of the same workbook. I want to avoid that . I would be referencing just the copy from C:\Subbby\Subbby Dance\Trial\

Therefore, is there a way to do this ? something like

I have a workbook open and I want a code to

1. find the current workbook's location,
2. copy this same workbook in a predefined location (C:\Subbby\Subbby Dance\Trial\) and
3. then go back to original file and delete it ?

Originally Posted by subbby

I have a workbook open and I want a code to

1. find the current workbook's location,
2. copy this same workbook in a predefined location (C:\Subbby\Subbby Dance\Trial\) and
3. then go back to original file and delete it ?

Please Login or Register  to view this content.

Correct; you're using the new copy after the macro is run.

SaveAs creates a new copy and closes the original. Once the original is closed, it's killed.

Please Login or Register  to view this content.

FYI: .SaveCopyAs saves a copy of the workbook but the original workbook remains opened and the copy is closed.