View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
John O'Boyle John O'Boyle is offline
external usenet poster
 
Posts: 6
Default Macro help anyone.....

Actually, thank you, I tried it (before I saw this note) with lines #1 &
#4. Everything seems to work as advertised. Do I really need line #2?

Thanks.
JLOB


Bob Phillips wrote:
Sub yourMacro()

Application.DisplayAlerts = False
ActiveWorkbook.SaveAs Filename:="C:\myDir\myBook.xls"
' rest of code
Application.DisplayAlerts = True

End Sub