indupriya9
Programmer
Hi Gurus
I have recorded a macro to import xml files into excel 2003. Importing one file is achieved through this. What I need is a macro that will loop through all the xml files in the directory specified and import data into excel and append the results. All these xml files have the same structure.
The code so far is as follows:
Can anyone please help me with the ocde to loop through all the files in the directory?
Thanks in advance
ip
I have recorded a macro to import xml files into excel 2003. Importing one file is achieved through this. What I need is a macro that will loop through all the xml files in the directory specified and import data into excel and append the results. All these xml files have the same structure.
The code so far is as follows:
Code:
Sub XMLimport()
ActiveWorkbook.XMLimport URL:= _
"[URL unfurl="true"]http://intranet/budgets/Project_Budgets/1111.xml",[/URL] ImportMap:=Nothing, _
Overwrite:=False, Destination:=Range("$A$1")
End Sub
Can anyone please help me with the ocde to loop through all the files in the directory?
Thanks in advance
ip