Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Search one worksheet for values in another worksheet? | Excel Discussion (Misc queries) | |||
Worksheet not showing up in VBE | Excel Worksheet Functions | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions |