>I want to get the path as "\Data\ABC\XYZ\123.ps" From "E:\Data\ABC\XYZ\123.ps". What is the function to get so ?
>
>Harsh
Hi,

You want to specify a file in your path?? Why not only the directory? That is where we usualy use the path setting for, anyway to get to "\Data\ABC\XYZ\123.PS" from "E:\Data\ABC\XYZ\123.ps" try:

lcPath= "E:\Data\ABC\XYZ\123.ps"

right(m.lcPath,len(m.lcPath)-3)

Regards,

Koen