rename workbook?

[Claude]

Hi all
Is there a way of renaming a workbook without first
saving it?

 

[Frank Kabel]

Hi Claude
as far as I know you need to save it under a different name (as the
workbook name is the filename). Also the name property of the workbook
object is read-only

 

[Claude]

thanks Frank, that confirms what I thought as well...

 

[Ron de Bruin]

If you want to rename a existing file without opening it
you can use this

From the VBA help
**************************

Name Statement Example
This example uses the Name statement to rename a file. For purposes of this
example, assume that the directories or folders that are specified already
exist. On the Macintosh, "HD:" is the default drive name and portions of the
pathname are separated by colons instead of backslashes.

Dim OldName, NewName
OldName = "OLDFILE": NewName = "NEWFILE" ' Define file names.
Name OldName As NewName ' Rename file.

OldName = "C:\MYDIR\OLDFILE": NewName = "C:\YOURDIR\NEWFILE"
Name OldName As NewName ' Move and rename file.

 

[Don Lloyd]

Hi,

One way would be to save the workbook under it's new name and then
delete(kill) the original..

Regards,
Don