read datas from XML to excel using VBAmacros
DEar Friend,
i have tried this, but i cooldnot do this please help me to do this please
code:
Dim eMessage As String
Dim xlApp As Excel.Application
'AppActivate("Microsoft Excel")
'xlApp = GetObject(, "Excel.Application")
xlApp = CreateObject("Excel.Application")
xlApp.Workbooks.OpenXML("C:\sample .xml")
ChDir("C:\")
xlApp.AlertBeforeOverwriting = False
xlApp.DisplayAlerts = False
xlApp.ActiveWorkbook.SaveAs(Filename:="C:\sample .xls")
xlApp.AlertBeforeOverwriting = True
xlApp.DisplayAlerts = True
If Not xlApp Is Nothing Then
xlApp.Quit()
xlApp = Nothing
End If
|