View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Mainframer Mainframer is offline
external usenet poster
 
Posts: 3
Default Export multiple Excel sheets to a single text file

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
.