Create workbooks from worksheets

Guest · Feb 28, 2006

Does anyone know an easy way to create multiple single-sheeted workbooks from
a single multi-sheeted workbook?

What I am actually trying to do is create multiple csv files for data import
from a workbook that contains many worksheets.

Chip Pearson · Feb 28, 2006

Try some code like

Sub AAA()
Dim WS As Worksheet
For Each WS In ThisWorkbook.Worksheets
WS.Copy
Next WS
End Sub

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

message
news:[email protected]...

Guest · Feb 28, 2006

See Ron de Bruin's code at

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

Guest · Feb 28, 2006

Works a treat. Thanks a lot!

Ian

Duke Carey said:
See Ron de Bruin's code at

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

consolidate workbooks to worksheets in one workbook?	1	Jul 15, 2009
converting from lotus, file explodes in size	1	Aug 18, 2003
Create formula that combines numbers from multiple workBOOKS?	1	Jul 24, 2009
multiple workbooks in one file	3	Mar 26, 2009
Need to merge worksheets - Excel 2003	0	Jul 19, 2013
Editing Data in Multiple Worksheets/Workbooks	1	Oct 6, 2008
How do I look at two worksheets in one Excel workbook at same time	2	Jun 4, 2010
Merge Multiple workbook sheets into one workbook	0	Aug 6, 2014

Create workbooks from worksheets

Guest

Chip Pearson

Guest

Guest

Ask a Question

Similar Threads