View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default 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