G Guest Jan 23, 2004 #1 I need to use VBA to automaticaly rename an excell file, the file that needs to be renamed is not open at the time.
I need to use VBA to automaticaly rename an excell file, the file that needs to be renamed is not open at the time.
R Ron de Bruin Jan 23, 2004 #2 You can use this OldName = "C:\Data\OLDFILE.xls" NewName = "C:\Data\NEWFILE.xls" Name OldName As NewName
You can use this OldName = "C:\Data\OLDFILE.xls" NewName = "C:\Data\NEWFILE.xls" Name OldName As NewName