Copy and Save one Sheet from Excel Workbook 1

[netrusher]

I have an excel workbook with 12 sheets. I would like to be able to create a macro that would copy and save
one sheet from the workbook to another network location. Any advice on how to do this. The sheets
are named for the months so I have sheets January - December. At the end of this month I would like to save
and send the January sheet to the location I need and also give it a new name.

Thanks for all help.

 

[xlbo]

Have a look in the FAQs in the VBA forum: Forum707

This has been covered there

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[netrusher]

Thanks,

There are a lot of pages on the link you provided can you
narrow it down a little bit?

 

[xlbo]

The link I provided goes to the VBA forum - Not particularly hard to go to the FAQs in there and find this one: faq707-2482

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question