View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
romelsb romelsb is offline
external usenet poster
 
Posts: 117
Default SAveAs worksheet

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