file transfer

R

rvik

hai

i have a form which users fill it. The form contains fields to ente
msword file names. On submission of the form, i would like to transfe
the msword file from its current location toa different location


can it be done??

thank
 
R

Ron de Bruin

You can use Name

Name statement
Renames a disk file, directory, or folder.

OldName = "C:\Data\a.xls"
NewName = "C:\NEWFILE.xls"
Name OldName As NewName
 
R

rvik

but can the name of the file be taken from a variable or cell address.

users fill the name of the file in a cell address.

pls help me

thanks
 
Top