hitch_hiker
Active Member
- Joined
- Feb 21, 2012
- Messages
- 294
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
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
I plan on
VBA Code:
workbooks(invoice register).activate
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