Exporting Sheets & Naming new workbook & Breaking links

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
 
P

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

Similar Threads

Create New Workbook and copy sheets from my Speadsheet 4
Sheets to new WorkBook 4
Copying cells and formula from closed workbook to all sheets in open workbook 0
VBA code for pasting links -- modifying RDB code for summary workbook 10
Copy and paste sheets to new workbook 14
Copy two sheets from workbook & create new workbook 8
Copy sheets to New Workbook - Excel 2007 1
Select specific sheets and copy to new workbook 2

Top