Saving a copy of excel file in macro but have it auto write
Try:
Application.DisplayAlerts = False
before the code to turn warning messages off, and
Application.DisplayAlerts =True
after the code to turn them back on.
Hope this helps.
Pete
On Mar 27, 4:21 am, "pano" wrote:
I have the below Macro but would like it not to ask the user before
overwriting the file anyway to do this????
Sub AASAVETOSTICK()
' AASAVETOSTICK Macro
' Macro recorded 19/03/2007 by *
'
ChDir "D:\"
ActiveWorkbook.SaveAs Filename:="D:\DWS.xls", FileFormat:= _
xlNormal, Password:="", WriteResPassword:="",
ReadOnlyRecommended:=False _
, CreateBackup:=True
End Sub
|