Checking if active file is correct version
 

Dear All,

I have two versions of a file, one current, and the other in template form
in a different folder.
Same filenames, different locations.

When user has one version open, I need to be able to check which version
before allowing my code to make changes.

All the file and string compare code extracts in this forum and elsewhere
don't seem to be doing exactly this, and I am having difficulties with
everything beyond checking the active filename and path!

Assistance much needed and appreciated,

Matilda

Checking if active file is correct version
 

check the path command

Activeworkbook.Path

--
Regards,
Tom Ogilvy


"Matilda" wrote:

Dear All,

I have two versions of a file, one current, and the other in template form
in a different folder.
Same filenames, different locations.

When user has one version open, I need to be able to check which version
before allowing my code to make changes.

All the file and string compare code extracts in this forum and elsewhere
don't seem to be doing exactly this, and I am having difficulties with
everything beyond checking the active filename and path!

Assistance much needed and appreciated,

Matilda