I have one workbook open during the whole process in which .xml files are imported.
So,

How do i get a macro which runs in a that open workbook.

And when any .xml-file is opened from outside (like double clicking a .xml-file on your desktop) into excel this macro automatically sets LoadOption:=xlXmlLoadImportToList and I don't get popup wich tells me to choose! Please!

Im not looking for:


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

Because macro doesn't open .xml, it should only set the LoadOption. Maybe generally setting LoadOption:=xlXmlLoadImportToList?