How does it know what the 'next' workbook is?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ctech" wrote in
message ...

The macro doesn't work as I want it to.

The macro you wrote terminates when the workbook doesn't contain the
specified sheet. But I want it then to close the workbook and try the
next workbook.


How can I do this?


--
Ctech
------------------------------------------------------------------------
Ctech's Profile:
http://www.excelforum.com/member.php...o&userid=27745
View this thread: http://www.excelforum.com/showthread...hreadid=483865