Check File Name With Conditional Statement

  • Thread starter Thread starter adambush4242
  • Start date Start date
A

adambush4242

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
 

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

Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
macro to print xps then save with name value in (B2) 8
Convert Multiple CSV Files to XLS Files (Again) 2
Exit a Procedure from a Sub within a sub 5
Saving a workbook with a makro 2
Using a Check Box to Lock/Unlock Cells 2
Macro to Copy From One Workbook To Another 3
Macros don't work when file name changes 2

Back
Top