Export multiple Excel sheets to a single text file
in [Programming]
|
From: Mainframer on 12 Feb 2010 21:55 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?
From: D_Rennie on 13 Feb 2010 01:48 Hello, Here are two lots of code one will put alll the sheest into sererate .txt on the c:/ drive. the other will make a temp drive and split out all the sheets into .txt files and then combine these into one .txt file C:\Output.txt
From: Ron de Bruin on 13 Feb 2010 07:16 Hi Mainframer For workbooks see http://www.rondebruin.nl/mergetotxt.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mainframer" <Mainframer(a)discussions.microsoft.com> wrote in message news:5F9C9944-BA99-4E04-BDC8-04EA416C782B(a)microsoft.com... >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?
From: Mainframer on 14 Feb 2010 23:55 I'll have to look at this in depth and see how applicable it is to my question. But for now, on the surface, it looks different. You are talking about merging multiple workbooks into a text file and I am talking about merging multiple worksheets to a text file. Thanks for the reply. "Ron de Bruin" wrote: > Hi Mainframer > > For workbooks see > http://www.rondebruin.nl/mergetotxt.htm > > -- > > Regards Ron de Bruin > http://www.rondebruin.nl/tips.htm > > > "Mainframer" <Mainframer(a)discussions.microsoft.com> wrote in message news:5F9C9944-BA99-4E04-BDC8-04EA416C782B(a)microsoft.com... > >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? > . >
From: Mainframer on 14 Feb 2010 23:57
Did I miss something here? I don't see any code. "D_Rennie" wrote: > > Hello, > > Here are two lots of code one will put alll the sheest into sererate > .txt on the c:/ drive. > > the other will make a temp drive and split out all the sheets into .txt > files and then combine these into one .txt file C:\Output.txt > . > |