saving only one sheet

**perko121** · 03-25-2010, 02:38 PM

hi all

now I'm using save copy macro for saving entire workbook but I would like to have the same but for saving only one sheet from workbook can someone correct my code?

here is code I use now

Please Login or Register  to view this content.

thank you

**JBeaucaire** · 03-25-2010, 03:09 PM

1) Identify the sheet to copy
2) Copy it with no destination causes it to copy into a new workbook
3) Save the new workbook, then close it

Please Login or Register  to view this content.

**royUK** · 03-25-2010, 03:20 PM

Doyou want to save one sheet as a separate workbook as JB suggests?

**perko121** · 03-25-2010, 04:23 PM

yes, that is correct, save only one sheet as new workgroup ... so how do I integrate this code with my code ?

**JBeaucaire** · 03-25-2010, 04:27 PM

Your code is doing something completely different. This code will need to complete the task on its own...

You can see the basic syntax already given, it just needs to be tweaked to match your unspecified requirements.

What are the parameters for knowing which sheet you want saved? (I used "Sheet1")

What are the parameters for naming this workbook? (I used "filename1sheetonly.xls")

You can see what it does, and what your original code does. Can you tweak it to do what you want? If not you'll need to describe FULLY how it needs to operate.