Screen updating = false but still get message box

[matty1973]

Hi,

When I run the following XML importing code I get a message box saying:

"The specified XML source does not refer to a schema. Excel will create a schema based on the XML source data.
[] In future do not show this message"

I turned off the screen updating because I hoped it would then ignore the message box and continue on it own but unfortunately it requests me to press the OK button. I appreciate that ticking the box would result in the message not being shown in future but is there a way to force it to continue on computers that have not yet had the box ticked?

Many thanks if you can help

Matt


Sub Test()


Application.ScreenUpdating = False

Range("A1").Select

ActiveWorkbook.XmlImport URL:= _
Sheets("Macro").Range("B2").Value _
, ImportMap:=Nothing, Overwrite:=True, Destination:=Range("$A$1")

Application.ScreenUpdating = False


End Sub

 

[AlphaFrog]

Try using something like this...

    Application.DisplayAlerts = False
    
        'Your code here
        
    Application.DisplayAlerts = True

 

[matty1973]

Thank you AlphaFrog that works perfectly.