Extract File names...

[asheshrocky]

Hi All,

I have a userform with two textbox.....
The value will be entered based on the file location which the user choose.

Suppose, for example it can be "

Please Login or Register  to view this content.

If this is choosen as the input file Directory,i need to create another directory in the same location like this

Please Login or Register  to view this content.

so the logic is i must extract all the text before the second '\' from the end and then create a directory named Output_directory,then the same filename as Input file name,

I need to achieve this using VBA code...
Can someone help me with this.

Regards
Ashesh

[Bob Phillips]

Try this

Please Login or Register  to view this content.

[asheshrocky]

Hi Phillips,

Am getting an object required error ar

Please Login or Register  to view this content.

[Bob Phillips]

Maybe your textbox is not called TextBox1.

[asheshrocky]

Hi Phillips,

It worked fine......thanx a lot for ur help.