Thread: Need to Export All Worksheets from All Workbooks in Folder to Separate FIles not as CSV Files
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
socrtwo socrtwo is offline
external usenet poster
  
Posts: 16
Default Need to Export All Worksheets from All Workbooks in Folder to Separate FIles not as CSV Files

Ron de Bruin wrote:
See this example for one file
http://www.rondebruin.nl/copy6.htm

You can use the code from this macro in a loop
See my site for code to loop through all files in a folder
http://www.rondebruin.nl/tips.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


Mr de Bruin. Thanks for taking an interest and replying. Your Website
is great. I think I've got everything working the way I need.

SIncerely Paul Pruitt (socrtwo)

Reply With QuoteReply With Quote