| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA to break out worksheets from a workbook
I have an excel workbook with something like 30 worksheet tabs, I need to get
these tabs broken out to individual files. The name of the tabs is what I would like to have the files named, but I also need them saved in a text tab delimited file format. Is there a code that can do this for me? Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VBA to break out worksheets from a workbook
Here is a sample:
Sub Macro1() Dim s As Worksheet For Each s In Sheets s.Activate t = s.Name ActiveWorkbook.SaveAs Filename:="C:\test folder\" & t, _ FileFormat:=xlText, CreateBackup:=False Next End Sub -- Gary''s Student - gsnu200908 "James" wrote: I have an excel workbook with something like 30 worksheet tabs, I need to get these tabs broken out to individual files. The name of the tabs is what I would like to have the files named, but I also need them saved in a text tab delimited file format. Is there a code that can do this for me? Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to break data into worksheets | Excel Discussion (Misc queries) | |||
| How do I break links in a workbook? | Excel Worksheet Functions | |||
| How do I break a link between cells in the same workbook? | Excel Discussion (Misc queries) | |||
| Want Excel to break links between worksheets in same file | Excel Worksheet Functions | |||
| How can i get my whole workbook highlighted in the page break pre. | Excel Worksheet Functions | |||
Linear Mode
