How to break dsifferent sections of the list in Excel into different files

K

kvo

Hello All!

Can somebody help with macro. The idea is: I have a list of categorie
of products in Excel spreadsheet and I need to break this spreadshee
and put those categories into different files (csv's). The number o
products in every category is different.

Please, help!!!!!:confused
 
R

Ron de Bruin

Hi

The examples on this page will create a worksheet for each item in your workbook.
http://www.rondebruin.nl/copy5.htm

You can save every sheet then as a CSV file with a loop

Dave Peterson posted this macro to save each sheet as a CSV

Sub testme()
Dim wks As Worksheet
Dim newWks As Worksheet

For Each wks In ActiveWorkbook.Worksheets
wks.Copy 'copies to a new workbook
With ActiveSheet
.Parent.SaveAs Filename:="C:\WINDOWS\TEMP\" & .Name, _
FileFormat:=xlCSV
.Parent.Close savechanges:=False
End With
Next wks

End Sub

(adjust the path)
 
Top