hi Darin

See
http://www.rondebruin.nl/copy6.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Darin Kramer" wrote in message ...


Hi There,

I have a single excel File with 20 sheets. I want to move each sheet to
a new book, so that I have 20 books (ie 20 Excel Files instead of one).

Is there VB out there to achieve this...?

Regards

Darin



*** Sent via Developersdex http://www.developersdex.com ***