View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
stevieb stevieb is offline
external usenet poster
 
Posts: 16
Default How to save an entireworkbook to individual text files?

I regularily work with workbooks that contain well over 20 worksheets per
book. After working with the data I always have to save each 'sheet' as an
individual *.txt file. All the sheets are saved using the worksheet name.

Is there any way to automate this process, ie. save all worksheets to a
respective *.txt file. For example, 20 sheets in a book, will result in 20
seperate *.txt files.

Steve