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?
Bookmarks