Howdy... I don't know VBA. I got the below code off the internet and modified it slightly and it works for renaming. It does a 'save as' and replaces part of the filename with the date... it then keeps the new file ('save as' file) open. Problem is, I want the original file open and the 'save as' file closed. I've tried adding various file close and open commands but to no avail.
Restated: After doing a 'save as', I want to close the 'save as' file and open the original file I was working with.
Thanks!
This renames file and keeps 'save as' file open.
Please Login or Register to view this content.
Bookmarks