If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|