Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Export multiple Excel sheets to a single text file
I want to export (SaveAs) multiple worksheets to a single text file. probably
csv. By Microsoft's design I can't do that with a straight Save As from the menu. So I thought maybe I could create a macro that would save each sheet one at a time. Unfortunately this doesn't seem to work because Workbook.SaveAs doesn't seem to have an append capability. Worse case is I save each sheet to a separate file and manually append them. Short of that, any programmatic suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
export excel colonm to a single text file | Excel Discussion (Misc queries) | |||
ExportAsFixedFormat for Multiple Sheets in a Single Excel File | Excel Programming | |||
ExportAsFixedFormat for Multiple Sheets in a Single Excel File | Excel Worksheet Functions | |||
Export many sheets to one text file | Excel Programming | |||
Export multiple sheets to 1 csv file. | Excel Programming |