View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
D_Rennie[_8_] D_Rennie[_8_] is offline
external usenet poster
 
Posts: 1
Default Export multiple Excel sheets to a single text file


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