Hi Tom. Ran across this thread today and your code was helpful to me as well.
I have a question. Using similar code, could I do the following:

I have a workbook with a seperate sheet for each employee. Our admin updates
their sales leads every day with entries on their sheets. I would like to use
a command button with your code. She could finish the entry on the master,
click to use your code to save their sheet as a seperate workbook in the same
folder. Then the salesperson could update their own sheet and use a command
button to then update their sheet in the master.

Problem is that the info would have to append and not overwrite so this
maybe impossible. Thank you for any help you can provide.

"Tom Ogilvy" wrote:

activesheet.copy ' creates a new one page workbook
' with a copy of the activesheet in it
' this becomes the activesheet/book
Activeworkbook.SaveAS "C:\MyFolder\" & activesheet.name & ".xls"
Activeworkbook.Close SaveChanges:=False

--
Regards,
Tom Ogilvy


"BigPig" wrote in message
...
Is it possible to save just a worksheet out of a workbook that is quite
large?

Example: I have a user form that extracts data from a worksheet labeled
'data', and with a command button inputs the data into another worksheet
labeled 'form' in the same workbook. The userform also allows the user to
change the information on the user form if it is incorrect, and then with
the
command button populate the appropriate fields on the form (worksheet
formatted to look like a commonly used form).

Since the workbook's size is upwards of 1 meg, and each applicant would
have
to be saved, I thought the best way would be to save just the form with
the
data put into it. I have tried several different ways via this website and
others, but I am a novice vba user.

Please help! Thankyou.