[sotisanis]

βρηκα αυτον τον κωδικα.για τοπικα δουλευει αλλα πως θα το βαλω να δουλευει μεσω url ?

Sub ImportXMLtoList()
Dim strTargetFile As String
Dim wb As Workbook

     Application.ScreenUpdating = False
     Application.DisplayAlerts = False
     strTargetFile = "C:\dap.xml"
     Set wb = Workbooks.OpenXML(Filename:=strTargetFile, LoadOption:=xlXmlLoadImportToList)
     Application.DisplayAlerts = True

     wb.Sheets(1).UsedRange.Copy ThisWorkbook.Sheets("proionta").Range("A1")
     wb.Close False
     Application.ScreenUpdating = True


End Sub