ExcelBanter - Saving tabs into separte books

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Saving tabs into separte books (https://www.excelbanter.com/excel-programming/438010-saving-tabs-into-separte-books.html)

Darin Kramer

Saving tabs into separte books

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 ***

Ron de Bruin

Saving tabs into separte books

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 ***

All times are GMT +1. The time now is 01:57 AM.