hai

a cell address contains a file name. i want the file name in the cel
address to be the input for the code below, so that the file is copie
to a new location....i.e. instead of the "test.doc", i should have th
file name mentioned in the cell address


Sub file_trf_copy()
oldname = "C:\test.doc"
newname = "\\....\test.doc"
FileCopy oldname, newname
End Sub
test.do

--
Message posted from http://www.ExcelForum.com