Active Folder Name

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Active workbook folder name	Jasoni	Microsoft Excel Programming	2	2nd Oct 2008 08:53 AM
Active Folder in Mail too dim	John	Windows Vista Mail	6	13th Dec 2007 03:43 AM
No active prefetch folder	Bill Woods	Windows XP General	5	12th Mar 2005 01:28 AM
No active prefetch folder	Bill Woods	Windows XP Performance	5	12th Mar 2005 01:28 AM
Active D and Sercurity right to folder	Mike	Microsoft Windows 2000 Active Directory	1	28th Jun 2004 09:26 PM