View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rob Fenwick Rob Fenwick is offline
external usenet poster
 
Posts: 2
Default Export Multiple worksheets to text files

Has anyone exported from excel multiple worksheets to individual files?
I want to have each file named the contents it's respective worksheet.
Only 1 column of data is to exported column "A". Rows are all the same
in each worksheet.

I would like to use notepad as the application and save the files as
*.par extensions for a diff apps use.

Thank you

Rob

*** Sent via Developersdex http://www.developersdex.com ***