View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Close with no pop-up?

Hi All.....

I have a macro that opens a second workbook and does things with it and then
I want to close it, but then I give it the following code, the macro stops,
and I get a pop-up that asks "Do you want to save?".....No, I don't want to
save and No, I don't want the pop-up to stop my macro operation.........how
please can I close the other workbook without getting the pop-up?


'Close the q793Complete workbook
Windows("q793Complete.xls").Activate
ActiveWorkbook.Close

TIA
Vaya con Dios,
Chuck, CABGx3