View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] bormesh@gmail.com[_2_] is offline
external usenet poster
 
Posts: 1
Default Excel Addin using SaveAs Function

Thanks Tom,

That solved it. The DisplayAlerts property works in .NET also,
apparently. Thanks again.

-Rob


Tom Ogilvy wrote:
In VBA you can suppress this with

Application.DisplayAlerts = False
' do the save
application.displayAlerts = True

this is not a persistent setting, so it isn't a parameter you can set
outside of using code.

I am not sure it will work form .NET, so you might just need to delete the
file before doing the save.

--
Regards,
Tom Ogilvy