sourceWb.Close SaveChanges:=False

--
Regards,
Tom Ogilvy


"Newbie80" wrote in
message ...

Im opening a different workbook and Im copying a sheet from it. Thought
I opened it as readonly, but sometimes it still asks if I want to save
the changes.

Set sourceWb = Workbooks.Open(filepath, True, False)
.......
.............
(can I write something like sourceWb.Don'tSave or something)

sourceWb.Close


--
Newbie80
------------------------------------------------------------------------
Newbie80's Profile:
http://www.excelforum.com/member.php...o&userid=25946
View this thread: http://www.excelforum.com/showthread...hreadid=394562