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).
|