ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   XML and xpath (https://www.excelbanter.com/excel-programming/382750-xml-xpath.html)

Kai I. H.

XML and xpath
 
Hi,

I'm developing an vba makro in excel. I read a xml file and extract
some information from that xml file and write it into an excel sheet.

Until now we used an xslt to create the output html file from the
above mentioned xml file. The html file was formatted via an xsl file.
But this was quite unsatisfying because xsl is not really good to
calculate data, do iterations, and so on.
So we decided to implement that with vba to create an excel file.
Now I need the xslt-functions that I used in the xsl file, like
"key(...)" or "current()". Is there any similar available in the excel-
vba-xml-functions?

Thanks in advance,

Kai



All times are GMT +1. The time now is 06:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com