Exporting Sheets & Naming new workbook & Breaking links

  • Thread starter Thread starter Roger on Excel
  • Start date Start date
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
 
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

Export Sheet Values to new workbook 20
Create New Workbook and copy sheets from my Speadsheet 4
Save each sheet of multi-sheet workbook as a single-sheet workbook 3
Copying cells and formula from closed workbook to all sheets in open workbook 0
Duplicate all Macros? 2
Copy a sheet from one workbook to another 1
Copy and paste sheets to new workbook 14
Adding New Sheets 2

Back
Top