View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ron Finer Ron Finer is offline
external usenet poster
 
Posts: 1
Default How do I extract multiple tabs from an Excel workbook?

Is there a way to extract all of the tabs in a single workbook so as to
create individual workbook files labeled with the name of each tab? For
example, if I have a single XLS file with 15 tabs, is there an easy way to
extract all 15 tabs to 15 separate XLS files, each named for the name on the
original tab...