View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Carroll[_2_] Carroll[_2_] is offline
external usenet poster
 
Posts: 31
Default Saving Multiple Sheets to Another Spreadsheet Without Leaving the Initial Workbook

Hello,

I have a workbook that has 7 sheets. I need to create 3 spreadsheets
out of this: 4 sheets to one spreadsheet, 2 to another and 1 to a
third.

Using VBA, is there a way to do this without leaving the original
spreadsheet?

Thanks,

Carroll Rinehart