I send you a private mail
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Colin Hayes" wrote in message ...
In article , Ron de Bruin writes
Hi
With code you can do this
http://www.rondebruin.nl/copy6.htm
Hi Ron
OK I tried this. I pasted the code from your page into my macro and hoped it would take each of the 50 sheets in turn and save
them out as individual xls files. They're just numbered 1-50.
Unfortunately , it only saved three files , all of them empty! I'm doing something wrong , clearly. I'll try again.
Best Wishes
Colin