file transfer

[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

 

[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

 

[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

 

[Ron de Bruin]

Use this

Sheets("Sheet1").Range("A1").value