Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to break dsifferent sections of the list in Excel into different files
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 -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to break dsifferent sections of the list in Excel into different files
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) -- Regards Ron de Bruin http://www.rondebruin.nl "kvo " wrote in message ... Hello All! Can somebody help with macro. The idea is: I have a list of categories of products in Excel spreadsheet and I need to break this spreadsheet and put those categories into different files (csv's). The number of products in every category is different. Please, help!!!!! --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I BREAK DOWN FILES? | Excel Discussion (Misc queries) | |||
How do I break a large .CSV file into several small Excel files? | Excel Worksheet Functions | |||
Subtotaling sections is the same list | Excel Discussion (Misc queries) | |||
Totaling sections within a list | Excel Discussion (Misc queries) | |||
Why do my links break when I burn multiple Excel files to a CD? | Excel Worksheet Functions |