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.
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