Yes, that's what he is doing/trying to do. Notice that he is saving as file
type xlText, not as a regular .xls file. When saving as .txt, .csv and
probably a couple of other types, only one sheet from the book can be saved
at a time anyhow. So singling out a specific sheet shouldn't be the issue -
the active sheet is the one by default.

Problem right now is that he cannot stop the alerts from popping up during
the save or SaveAs process. Go back to his first post. He says he's even
getting the "Do you want to save changes you made to results.mea" - which
shouldn't even come up since he is (should be) already in the middle of a
save operation. Then he is getting the usual "file exists.. overwrite?"
prompt, which should be suppressed with the
Application.DisplayAlerts=False
statement, but isn't being for him.

The first prompt should only be coming up if he's trying to close the
workbook.

His response below is asking for any other way to suppress those messages,
and right this minute I cannot think of one.

"romelsb" wrote:

Excuse me JL...hey Bryan...Are u trying to say is to save changes on a single
worksheet within a workbook containing "n" numbers of worksheets ? Ill try if
u reply!!!

"Brian Young" wrote:

Hi JL

Unfortunately I had already tried this but with no success. Any other
suggestions ??? thx

"JLatham" wrote:

Application.DisplayAlerts = False
...your save as code here
Application.DisplayAlerts = True

"Brian Young" wrote:

I have a macro that reads in, processes data & places it onto a presentation
worksheet. The following line allows ONLY the worksheet to be saved which is
what I want. My problem is that I get the 2 messages appearing & I want to
switch them off so that filing of the worksheet is automated.

Any suggestions ??

SaveAs Filename:="c:\ptp\results.mea", FileFormat:=xlText

Message 1 :"Do you want to save changes you made to results.mea"
&
Message 2 :"The file Results.mea already exists. Do you want to overwrite ?

Using - Application.DisplayAlerts = False does not work.

Brian