View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bill Kuunders Bill Kuunders is offline
external usenet poster
 
Posts: 303
Default Rename a new workbook

An example

ActiveWorkbook.SaveCopyAs "c:\backup\currb4roll.XLS"

Guessing you want to save a copy but keep on going with the existing old
file.

--
Greetings from New Zealand
Bill K

"Jan Eric Nilsson" wrote in message
...
Is it possible through VBA to create a new Workbook and also assign a
given name to the Workbook without having the Workbook saved?

Best Regards

Jan Eric