I am opening up a second workbook from the main one, pasting some data over from its sheets and then closing. For some reason, the close is suddenly taking a rather long time (2 or 3 seconds). If I don't copy/paste, then it shuts down immediately. BTW--it's not the copy/paste that is taking time (I have tested this), but simply the close.
Any ideas? I have tried turning off calcualtion.
Workbooks("myWorkbook").Close SaveChanges:=False
Cheers,
Vuk.
Any ideas? I have tried turning off calcualtion.
Workbooks("myWorkbook").Close SaveChanges:=False
Cheers,
Vuk.