Hello all,
I'm looking to save my excel workbook with a date/time stamp whenever cell B1 equals a 1, which I have working just fine. However I want the original workbook to stay open, not what I had just saved.
Attached is my formula, could someone look at it for me?
Mike
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by arlu1201; 10-09-2012 at 07:32 AM. Reason: Add code tags in future.
Have a look at SaveCopyAs
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Dah, I guess it's to early in the morning ti start thinking logically.
Thank You for your help.
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks