View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Audio_freak Audio_freak is offline
external usenet poster
 
Posts: 12
Default How to save each sheet as a separate excel-file


Hi, Happy New Year

Could anybody assist me with the code for saving each sheet to a separate
(newly created) file?

So that if I have an excel-file with 20 sheets, I would like a macro to
create 20 separate files.

The new files could get the same names as the sheets (preferably) or the
names could be taken from a cell in the relevant sheet.

Thanks for any help you can give.

Peter