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
|