| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
If, Then, Else Coding Problem
Works like a dream - Thanks so much
"Karim Benabd" wrote: If you want to test whether the active workbook name start with EM_ then try this: Sub CheckFileName() ' If File Name Starts with 'EM_', Then Process CALL Not Allowed ' If File Name does NOT start with 'EM_', Then Exit Sub 1 Dim FName As String FName = ActiveWorkbook.Name 2 If Left(FName, 3) = "EM_" Then 3 Call NotAllowed 4 Else: Exit Sub 5 End If |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with my coding problem? | Excel Worksheet Functions | |||
| problem with coding | Excel Programming | |||
| Please help: Coding Problem | Excel Programming | |||
| Coding problem | Excel Programming | |||
| Excel Coding Problem | Excel Programming | |||
Threaded Mode
