Check File Name With Conditional Statement
 

I have a file that certain users will open, rename, and use for testing
purposes. It contains a macro that I only want to run if the file is the
original version. I tried adding an if statment to the macro checking the
filename and only running the macro if the filename is the original. For the
original file the code works fine but if a file with a different name tries
to run the macro Excel shuts down everytime. I tried using the
ActiveWorkbook.Name and ActiveWorkbbok.FullName properties but both return
the same results. Any ideas?

Thanks

Adam Bush

Check File Name With Conditional Statement
 

Never mind I figured it out.

" wrote:

I have a file that certain users will open, rename, and use for testing
purposes. It contains a macro that I only want to run if the file is the
original version. I tried adding an if statment to the macro checking the
filename and only running the macro if the filename is the original. For the
original file the code works fine but if a file with a different name tries
to run the macro Excel shuts down everytime. I tried using the
ActiveWorkbook.Name and ActiveWorkbbok.FullName properties but both return
the same results. Any ideas?

Thanks

Adam Bush