The only alternitive to what Dave said will be to use the SaveAs method of
the Worksheet object which will save the specified sheet as a stand alone
File

"PCLIVE" wrote in message
...
I have a workbook where I may update information on a specific sheet and
then on another sheet I may have made some modifications that I do not want
to keep.

Is there a way to update a file saving only the changes in a worksheet
that I specify and not save anything else from other sheets in the
workbook? Basically, the other worksheets in the file would remain
unchanged, but the specific sheet would be saved or updated in the file.

Is there a way to do this?

Thanks,
Paul

--