ensure correct workbook

[hitch_hiker]

I am saving "save as" a workbook, when I am doing this I expect 3 workbooks will be open at the same time, also because I am using a keyboard shortcut "ctrl j" I need to avoid a typo saving any other workbook I happen to be in to be saved as and more importantly overwrite the intended file.
I plan on

workbooks(invoice register).activate

my logic is even if the file is closed, the macro will open the file and save it.
1? would this be the correct way, or is there a better way?
2? would I need to include the complete path and what would be the sytntax for that.
Sorry for the really easy question, my search so far hasn't directly addressed my situation

 

[severynm]

This is a Windows (and probably mac) functionality - the os will not allow you to save over any file that's already open. You'll get an error from excel that saving is not possible. Saving a file with the full path is very simple - just input the full path (including the extension) as a string, i.e.,

WorkbookName.SaveAs "C:\Temp\Encoding Time.csv"

I'm not entirely sure what you are trying to accomplish with the .Activate - that will only put focus on the specified workbook if it is already open, and will error if the specified workbook is not open. If you are trying to see if the workbook name entered is one of the ones you have open, you can use an if statement to help, i.e., in pseudocode, if workbookname = prohibitedname1 or if workbookname = prohibitedname2 .... then .... end if