Thread: When recording
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz[_2_] JLGWhiz[_2_] is offline
external usenet poster
 
Posts: 1,565
Default When recording

Or use:

ActiveWorkbook

But that only works so long at the new workbook is active. The best thing
is to name the workbook as soon as it is created.

myPath = ThisWorkbook.Path '<<<Change as applicable

Set newBk = Workbooks.Add
'Rename and save the file simultaneously.
newBk.SaveAs = myPath & "\Somename.xls" 'Or xlsx or xlsm, etc.

Workbooks("Somename.xls").Close

"Copacetic" wrote in message
...
I open or "add" a new workbook.

It records fine, but the call to "book7" is hard coded, and in the
future, the code will not be seeing "book7", so how do I call the newly
created workbook by other than its creation name? (I suppose I could
simply name it).