Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exporting from multiple worksheets to single text file
Hi,
I have an Excel file with multiple worksheets (containing over 65,000 rows of data in total). I want to export all the info from all sheets into a single text file (all the sheets are in the same format). I can manage to export each sheet into a separate text file using the following code: ---- Dim SheetCounter As Integer For SheetCounter = 1 To Sheets.Count Sheets(SheetCounter).Activate ChDir "P:\" ActiveWorkbook.SaveAs filename:= _ "P:\" & ActiveSheet.Name & ".txt" _ , FileFormat:=xlText, CreateBackup:=False End If Next ------ Could someone let me know how to export data from multiple sheets into a single text file. Many thanks, Chris Dunigan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exporting from multiple worksheets to single text file
Thanks for the quick reply.
The suggestion is great for myself, however the premise of the spreadsheet is that inexperienced users simply click a button and the code does everything else. I wonder if there is a way to automate this task. Thanks, Chris *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exporting from multiple worksheets to single text file
Here is a reference for how to write code to work with text files:
http://support.microsoft.com/support...eio/fileio.asp File Access with Visual Basic® for Applications -- Regards, Tom Ogilvy "Chris Dunigan" wrote in message ... Thanks for the quick reply. The suggestion is great for myself, however the premise of the spreadsheet is that inexperienced users simply click a button and the code does everything else. I wonder if there is a way to automate this task. Thanks, Chris *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems printing/exporting multiple worksheets with Excel 2007 | Excel Discussion (Misc queries) | |||
Printing single pages from multiple worksheets in a single print job | Excel Discussion (Misc queries) | |||
Printing multiple worksheets to one single pdf file | Excel Discussion (Misc queries) | |||
Single text file imported to multiple worksheets | Excel Worksheet Functions | |||
Exporting Text File | Excel Programming |