How to check where is stored .ebm file?

[sagitt]

Hi All,

I need to check if .ebm file that contains a macro is stored in a specific folder (basically I do not want the users to copy a macro file to their personal folders). In Excel this is very simple. Say I have MyFile.xls saved in C:\MyFolder folder. So the code is like that:

if activeworkbook.path <> "c:\myfolder" then exit sub

Question is how do I get this done in extra basic?

regards, sagitt