Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Renaming a file
I need to use VBA to automaticaly rename an excell file, the file that needs to be renamed is not open at the time.
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Renaming a file
You can use this
OldName = "C:\Data\OLDFILE.xls" NewName = "C:\Data\NEWFILE.xls" Name OldName As NewName -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl "Paul C" wrote in message ... I need to use VBA to automaticaly rename an excell file, the file that needs to be renamed is not open at the time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Renaming an excel file that is Linked. | Excel Worksheet Functions | |||
VB file renaming. | Excel Worksheet Functions | |||
Renaming A File | Excel Discussion (Misc queries) | |||
Renaming File Removes Worksheets | Excel Discussion (Misc queries) | |||
Copying and renaming a file | Excel Discussion (Misc queries) |