Does anyone know how to reference the new workbook that is created when you use the sheets(sheet1).copy without a before or after qualifyer?
It looks like it is just Book(n).xls where n is an incriment on the last new workbook created. I know I could compare the list of open workbooks before and after this event but that seems a bit messy. Is there a way I can assign the new book to an object variable? (have tried Set ObjectVar = sheets(sheet1).copy - no luck )