transfer xml data to excel

[Miss Piggy]

hi,

how to export XML data from a datagrid to excel sheet?thanks.

[HanneSThEGreaT]

Hello again MP!

This link should help !

[RobDog888]

If you have your xml file already on your filesystem then you can just use the .OpenXML function when the user clicks on the Export button.

Ha, saw you over at vb forums.

Dim moApp As Excel.Application = DirectCast(CreateObject("Excel.Application"), Excel.Application)

'...
Dim oWB As Excel.Workbook = moApp.Workbooks.OpenXML("C:\MyXML.xml")