troubleshooting Question

Macro to save daterev and time

Avatar of baber62
baber62 asked on
Microsoft OfficeMicrosoft ExcelMicrosoft Applications
14 Comments1 Solution482 ViewsLast Modified:
I have a macro which needs a little tweaking. The macro currently saves file with date revision number and time. It's working fine. However, I now need to adapt this macro.

I have say two folders as follows:

(1) C:\Current file folder and
(2) C:\Superseded file folder


1. When file is opened from folder (1) to save in folder (2) with date/revision number/time stamp.

2. Then when closing or saving the file in folder (1) to overwrite or kill the existing file and save with date/revision/time stamp.

3. If, however, there have been no changes made to the file. Then just allow close without adding new date/revision/time stamp

I would be satisfied with a solution which would cover the first two points above and would add extra points if solution covered all three points.
SaveNumberedVersion.txt
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 14 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 14 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros