bhofsetz Wrote:
You have to have an open workbook for the sheets to be copied to so have
the code create a new workbook with the desired name in the desired
path. Then copy all the visible sheets to that workbook. Then save.

Ok I guess opening a new one will be ok.

bhofsetz Wrote:
I'm not sure why you are getting a | Run-Time Error 9 | | subscript out
of range | error if the destination workbook is open.
Try copying and pasting my code directly into a module and run it as is
to see if you still get the same error.

I tried pasting this code into a module and I still get the error.
I will post my worksheet tonight at home for download at
http://www.wieduwilt.us/excel

I just can not figure out what is going on, there could be a conflict
with the existing code.


--
swieduwi
------------------------------------------------------------------------
swieduwi's Profile: http://www.excelforum.com/member.php...o&userid=21962
View this thread: http://www.excelforum.com/showthread...hreadid=380140