You also have to have this so the pop up doesn't come up:

VB Code:
  1. objExcel.DisplayAlerts = False

That line lets you save, close, exit without the "Yes - No - Cancel" dialog box popping up. Later, Jeremy