Help with code to change file name PLease

[Les]

Hi all, i have a string variable with the path that i retrieved my file from
and i need to save the file after manipulation to the same path, just with a
"ZA_" in front of the file name. e.g.
Get:
\\nv09001\za-t-m-2$\Department\T-M-22\Kevin\Projects\EM-13 SBM Workshops
07\FII 08\LIPEK_2008_080429.xls

Save:
\\nv09001\za-t-m-2$\Department\T-M-22\Kevin\Projects\EM-13 SBM Workshops
07\FII 08\ZA_LIPEK_2008_080429.xls

Thank you for any help in advance..

 

[Rick Rothstein \(MVP - VB\)]

Try this code structure...

GetName = "c:\dir1\dir2\dir3\file.txt
LastSlash = Instrrev(GetName,"\")
SaveName = Left(GetName, LastSlash) & "ZA_" & Mid(GetName, LastSlash + 1)

Rick

 

[Les]

Thanx Rick


--
Les

Try this code structure...

GetName = "c:\dir1\dir2\dir3\file.txt
LastSlash = Instrrev(GetName,"\")
SaveName = Left(GetName, LastSlash) & "ZA_" & Mid(GetName, LastSlash + 1)

Rick