| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Active Folder Name
Hi all, How do you find the name of the "active folder" not the whole CurDir path just the folder name which can be used to validate if user is in the correct folder. many thanks/sgl |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Active Folder Name
Try Msgbox Mid(curdir,InstrRev(CurDir,"\")+1) If this post helps click Yes --------------- Jacob Skaria "sgl" wrote: Hi all, How do you find the name of the "active folder" not the whole CurDir path just the folder name which can be used to validate if user is in the correct folder. many thanks/sgl |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Active Folder Name
Absolutely brilliant thank you vm/sgl "Jacob Skaria" wrote: Try Msgbox Mid(curdir,InstrRev(CurDir,"\")+1) If this post helps click Yes --------------- Jacob Skaria "sgl" wrote: Hi all, How do you find the name of the "active folder" not the whole CurDir path just the folder name which can be used to validate if user is in the correct folder. many thanks/sgl |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to update active workbook in one folder | Excel Worksheet Functions | |||
| Active workbook folder name | Excel Programming | |||
| Move Active Workbook to another Folder | Excel Discussion (Misc queries) | |||
| How to List the names of the subfolders present in the folder (path of folder is given in the textbox by user ) | Excel Programming | |||
| Save file in a new folder, but create folder only if folder doesn't already exist? | Excel Programming | |||
Linear Mode
