Exporting Sheets & Naming new workbook & Breaking links


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,


Patrick Molloy

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question