| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF Statement to Check for Blanks | Excel Worksheet Functions | |||
| If statement error check | Excel Worksheet Functions | |||
| Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
| How do I use a "check(ed) box" as a criteria in an "=if" statement | Excel Worksheet Functions | |||
| How do I check formatting in an if-then statement | Excel Worksheet Functions | |||
Threaded Mode
