Application.DisplayAlerts = True doesn't work in vba excel code

Question

I have a function that brings up the generic warning when merging two fields together. I want to suppress this message using vba. However after looking on the forums, I found that "Application.DisplayAlerts = True" should do the trick. However when I try to apply the code there is no option for Application. then display alerts. Do i have to import a specific library reference for this? I currently have Excel 14.0 imported..

Have you tried just putting Application.DisplayAlerts = True in your code? Do you get a compile error when compiling? — Barry
– Barry, Commented Oct 29, 2014 at 11:34
Yep, I get method or datamember not found and highlights the ".DisplayAlerts = true" — Chrislaar123
– Chrislaar123, Commented Oct 29, 2014 at 11:46
If I have a function that brings up the generic warning when merging two fields together. I want to suppress this message using vba, probably you might want to use Application.DisplayAlerts = False. Can you post the part of code which does not compile? — Matteo NNZ
– Matteo NNZ, Commented Oct 29, 2014 at 14:11
Do you get anything after typing Application. ? You say DisplayAlerts isn't there, are any of the following there? Application.EnableEvents Application.CellDragDrop. At a minimum check you have Microsoft Excel 14.0 Object Library checked in References. — Dave Brown
– Dave Brown, Commented Oct 29, 2014 at 14:15

Chrislaar123 · Accepted Answer · 2014-10-30 10:51:32Z

3

I found the resolution myself.

Because Application.DisplayAlerts = False was to set the access program that was calling on my create excel object to ignore any alerts displayed by access. So to solve it I simply wrote objExcel.DisplayAlerts = false

answered Oct 30, 2014 at 10:51

Chrislaar123

3212 gold badges6 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Felipe Over a year ago

I am dealing with the same problem but, unfortunately, I was not able to understand your solution. Could you provide more details?

Chrislaar123 Over a year ago

Basically I was using application.displayalerts = false, hoping that it would suppress warnings when doing stuff within an excel workbook when what you actually need to do is just use the instance name of the excel application declaration you're using rather than application.

Felipe Over a year ago

And how do you declare and set the variable objexcel?

Chrislaar123 Over a year ago

Dim objExcel As New Excel.Application

Collectives™ on Stack Overflow

Application.DisplayAlerts = True doesn't work in vba excel code

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related