code to check if user opened correct file

[maacmaac]

I am trying to display and check if a user is using the correct version of a file. I keep getting an error on "Workbooks.Filename" and can't figure out how to modify code. Thanks.

Please Login or Register  to view this content.

[davesexcel]

Where would you place a code like this?

[jaslake]

Hi maacmaac

This works for me

Please Login or Register  to view this content.

John

[maacmaac]

John,

Suggestion almost worked. If the workbook name is "Book2", the ActiveWorkbook.Name = "Book2". The ActiveWorkbook.Name is only recognizing the name of the workbook not the full path name. Is there a way to modify so it also reads the full path name?

Dave,

I am trying to prevent prying eyes from copying my file and placing a copy on another server for their own personal use. As an example, say my file is located on "O:/Department ABC/MetricsApplication.xls". I'm trying to prevent users from other departments copying my file and using it for their own use. So if someone were to copy my file to "O:/Department XYZ/MetricsApplication.xls", I want to prevent the file from opening. In a nutshell, if the file being opened is not located on "O:/Department ABC/MetricsApplication.xls", then don't open the file.

[maacmaac]

Just figured it out...use "ActiveWorkbook.FullName" instead of "ActiveWorkbook.Name"

Please Login or Register  to view this content.

[jaslake]

Yes...realized that when I read your last post...need to pick up FULL path and filename. Good detective work.

John