For Tom Ogilve re File check

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Tom,

Thankyou for your reply to my post
Checking if active file is correct version

I tried to reply but my browser won't co-operate, and I certainly didn't
wish to appear ungrateful!

Such a simple solution that has been eluding me for hours - at least the
syntax has.

This now works exactly as i wanted:


Public Function checkActiveFilename(sOpenFileName) As Boolean
Dim sNewFile As String
sNewFile = "C:\NewFolder\NewFile\"
If ActiveWorkbook.Path = sNewFile Then
checkActiveFilename = False
End If
End Function

Many thanks,

Matilda
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help to change code 4
Tom Ogilvy's Filter Check Function Adaptation Needed... 1
How to change closed file name - Error: file not found 5
Check a file into SharePoint 2
Check if Excel workbook is open via Word VBA, if open how to close it? 0
Dir function to check for file not reliable 6
VBA--Suppress error message,corrupt file or unrecognizable format 6
Check for file open/closed status 6

Back
Top