Getting Filepath from Selected input file

[szpt9m]

Hi All,

Can someone help me in getting full file path from selected input file?

I have a macro with text box and browse button.

User can click on browse button and it will allow them to select only text files.

Now for further processing I need to get the file path and file name in 2 different variables.

Like if user selected C:/Temp/Test.txt

Variable 1 should have C:/Temp
Varialble 2 should have Test.txt

Thanks in advance.

[bsalv]

"/" or "\" ????

Please Login or Register  to view this content.

[szpt9m]

Thanks BSALV.. used the secon method and worked as expected