View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Poli Poli is offline
external usenet poster
 
Posts: 2
Default Moving multiple worksheets as separate files

I have an excel file that someone put 100 or more sheets in the file. I need
to know how I can extract all the worksheets at the same time as separate
files that I can name maybe file1.xlsx, file2,xlsx etc.

Right now I have to move or copy each sheet one at a time and that is slow.

Thank you in advance for your help.

Pauline Moreno