How to disable application alerts On workbook opening!

I have an event for application.workbook opening..
On open it identifies the opened workbook and does needed things..
To this point it's ok, except when i try to open file.xml in excel.

There is a popupbox which i would like to, application.display.alerts = false..

Popup:

OPEN XML
Please select how you would like to open this file:
O As an XML list
O As a read-only workbook
O Use the XML Source task pane


The first option is the one i want to be "chosen silently"

Thx.

You can use this code:

Application.DisplayAlerts = False
Workbooks.OpenXML Filename:="C:\<path and file name>.xml", _
   LoadOption:=xlXmlLoadImportToList
Application.DisplayAlerts = True

It seems to work fine.

Regards,
Antonio

Thanks but the thing is that the code doesn't open the file.xml. I have a separate program which opens the files to excel. Just like double clicking file.xml.

I got some hint from you post but keep on helping if you know a way.

Maybe generally setting LoadOption:=xlXmlLoadImportToList?

I have this evenclass workbook open whenever i run the program which opens file.xml to excel. So the thing Im looking for should be located there.

Eventclass workbook has this code:

Option Explicit

Dim AppClass As New EventClass

Private Sub workbook_Open()

Set AppClass.App = Application

End Sub

EventClass has this code:

Option Explicit

Public WithEvents App As Application


Private Sub App_WorkbookOpen(ByVal Wb As Excel.Workbook)

Run macro:="personal.xls!mymacro"

End Sub

How do i get a macro which runs in a open workbook and when a .xml-file is opened ( just like double clicking a file ) into excel this macro automatically sets LoadOption:=xlXmlLoadImportToList and I don't get popup wich tells me to choose! Please!

Originally Posted by Korjaaja

How do i get a macro which runs in a open workbook and when a .xml-file is opened ( just like double clicking a file ) into excel this macro automatically sets LoadOption:=xlXmlLoadImportToList and I don't get popup wich tells me to choose! Please!

Hi Korjaaja, did you ever get a solution to this issue ? I am at the same point and cannot identify any way forward....