View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
arno arno is offline
external usenet poster
 
Posts: 184
Default Getting rid of Prompts in a macro

Hi Duncan,

you just need a line:

ActiveWorkbook.SaveAs Filename:="C:\otd\data\compile\International.xls", _
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False


ActiveWorkbook.Saved = true


ActiveWorkbook.Close



ActiveWorkbook.Saved = true

ActiveWorkbook.Close



do not use
application.displayalerts = false
unless you know what you're doing! Saved=true will do the job for you.

arno