Exporting Sheets & Naming new workbook & Breaking links
 

[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

Exporting Sheets & Naming new workbook & Breaking links
 

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



"Roger on Excel" wrote in message
...
[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