I am using Application.Fil eDialog to import (3) xml files. With .AllowMultiSele ct = true, I would like to import these three files in succession (breaks tables otherwise). My For Each statement looks like this:
Files are named in succession, like this:
<user> Import1 - 111710(1).xml
<user> Import2 - 111710(2).xml
<user> Import3 - 111710(3).xml
So "Import1" should import before "Import2", etc.
Any suggestions?
Thanks in advance,
Tux
Code:
For Each vrtSelectedItem In .SelectedItems
Application.ImportXML _
DataSource:=vrtSelectedItem, _
ImportOptions:=acAppendData
Next vrtSelectedItem
<user> Import1 - 111710(1).xml
<user> Import2 - 111710(2).xml
<user> Import3 - 111710(3).xml
So "Import1" should import before "Import2", etc.
Any suggestions?
Thanks in advance,
Tux