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

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

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


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"rvik " wrote in message ...
hai

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


can it be done??

thanks


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

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


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

Use this

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

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"rvik " wrote in message ...
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


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