what I want to achieve:
that any user which are doubleclick on a xml file will get this opened as "flatterned" (XlXmlLoadOption.xlXmlLoadOpenXml) without choosing on his own after the "open xml" window appears.
but whenever someone doubleclick on a xml file a little popup appears and ask how to open. I know how to open a xml file within vba code by knowing the path and filename but I want to catch this information after excel is running from doubleclick on a xml file.
The earliest event I found is the workbook_open event but at this time its to late. I put a "stop" in workbook_open() but after double click on an xml file first the little popup appears. After choosing one of the three the vbe stops at my "stop" code in workbook_open(). After that the xml data goes into the wb.sheet
Could anybody help me on that?
cheers Asterios
No comments:
Post a Comment