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
|