Hello people, Is anyone good at looping through workbooks? - im not,
I can perform a simple loop like this;
Dim wb As Workbook
Dim wbs As Workbooks
Set wbs = Application.Workbooks
For Each wb In wbs
MsgBox wb.Name
Next wb
The problem is when I replace the msgbox code with my macro it doesnt
work, or rather the problem is it works on the visible workbook then
fails to loop to any other workbooks.
I know this because my code has some handling error code that gives a
warning if you try and run the macro more than once on the same sheet.
Interestingly, If I have three workbooks open the error messgae will
appear twice indicating that VBA knows how many workbooks are open even
though it doesnt loop through them -
HELP very much appreciated - entire wont fit on here (although most of
it will be irrelevant to problem
Cheers - Greg
--
Turin
------------------------------------------------------------------------
Turin's Profile:
http://www.excelforum.com/member.php...o&userid=24987
View this thread:
http://www.excelforum.com/showthread...hreadid=466535