Thread: When recording
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Copacetic Copacetic is offline
external usenet poster
 
Posts: 17
Default When recording

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