Hi all..
How can I get rid of the warning - Do you want to save the changes you made to 'hb.xls'? when I try to close the work book?
Have tried each of the following with no luck
WBSN.Activate WBSN.Close savechanges:=False
WBSN.Activate WBSN.Close savechanges:=True
ThisWorkbook.Saved = True ActiveWorkbook.Close
Thanks in advanceThisWorkbook.Saved = True ActiveWindow.Close
Bookmarks