read datas from XML to excel using VBAmacros
"born2achieve" schreef in bericht
...
hi, i am newbie to this environment.i have one button in my
ExcelWorkbook.i
have sample.xml in my "c:\" i want to read that sample.xml and disply in
my
Excel Workbook if i click the button using VBA macro programing.please
can
any one show some exmple to do this please
A Button event to open the xml-file looks like this:
Public Sub OpenXML()
Workbooks.Open ("C:\sample.xml")
End Sub
This way the file will be opened in a new Excel window.
All you have to do is copy and paste the xml-data if you want it to be
displayed in a workbook that's already open.
|