Copy active sheet to a new workbook, close that work book and return

**nig_44** · 03-29-2012, 11:45 PM

Hi All

I am guessing this is an easy fix but I am fairly new to the world of vba.

I am using the following code to create a copy of a master workbook and save it by a user defined name. The problem is that this code creates a new workbook when all I want to do is copy the current values on the active sheet. Ideally I would like to save a copy of the acitve sheet, close that copy and return to the master workbook.

Any ideas?

Please Login or Register  to view this content.

**Mallycat** · 03-30-2012, 02:24 AM

If you want to learn, then use the macro recorder. Turn on the recorder, then do what you want, then stop the recording and look at what you have got.

so.....

turn on the recorder
right click the sheet and make a copy to a new workbook.
save it (give it a name)
close it

turn off the recorder.

Then work on the code that is recorded. You will learn a lot more than someone giving you the answer here. So give it a go and then when/if you have problems adapting it, then ask for help again.

Just my opinion

Copy active sheet to a new workbook, close that work book and return

LinkBack

Thread Tools

Rate This Thread

Display

Copy active sheet to a new workbook, close that work book and return

Re: Copy active sheet to a new workbook, close that work book and return

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions