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

copying to new workbook 0
VBA code for pasting links -- modifying RDB code for summary workbook 11
Create New Workbook and copy sheets from my Speadsheet 4
Exporting PivotCharts and PivotTables from a workbook without"breaking" them 0
Copy and paste sheets to new workbook 14
Sheets to new WorkBook 4
Copy two sheets from workbook & create new workbook 8
Severing links to list names when moving sheets between workbooks 1

Top