Exporting Sheets & Naming new workbook & Breaking links

  • Thread starter Thread starter Roger on Excel
  • Start date Start date
R

Roger on Excel

[Excel 2003]
Is there a way to programtically select certain sheets and copy them to a
new workbook? for example Sheet2 and Sheet3 to new workbook "New Project"

I know i can do this manually by selecting the sheets and right clicking to
get to the move/copy dialog, but it doesnt let you rename the workbook you
are creating.

Also how do you programitically break all links to the original spreadsheet?

Many Thanks,

Roger
 
you could copy then pastespecial values and then pastespecial formats
you name the new workbook when you save it
 
Back
Top