Changing file name

C

Craig

Is there a way in Excel 2003 to change the name of an excel file without
having to get out and go into Windows Exlorer to do it?
 
P

Peo Sjoblom

Yes, you can do another save as and give it a new name, then do file>open
and delete the old file from Excel without having to use Windows explorer.
Obviously you can't change the name of a file that is already open.. So if
you want to use a macro, the code has to close the file when it changes the
name and then open it again
 
B

Bob I

As long as it isn't the file you have currently open, Click File, Open,
select the file, press F2 and type in the new name, press enter.
 
Top