file transfer
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 |
file transfer
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/ |
file transfer
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/ |
file transfer
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/ |
All times are GMT +1. The time now is 05:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com