Try this (and yes, to rename you have to save...otherwise there will be nothing there. If you still want your old copy, then don't use the Kill line).On 2002-03-20 21:08, John wrote:
I need to rename a workbook without saving it. Is there any way of doing this in VBA, or any other way?
Thanks
ActiveWorkbook.SaveAs "MyFile.xls"
Kill "MyPreviousFileName.xls"
Hope this helps,
Russell
Like this thread? Share it with others