View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] omnicrondelicious@gmail.com is offline
external usenet poster
 
Posts: 23
Default Disable/ignore compatibility check during SaveAs

Wow. I don't think I've ever stumped Usenet before. No worries, I
figured it out. The solution was embarrassingly simple, natch:

Application.DisplayAlerts = False
With NewWkbk
.SaveAs Filename:=SavePath, FileFormat:=-4143, CreateBackup:=False
.Close SaveChanges:=False
End With
Application.DisplayAlerts = True

Got all fixated on the CheckCompatibility property that I just forgot
about good ol' DisplayAlerts...

..o.