I was write code for excel vba xml database values write into text file. when i using without any special characters xml values parsed into their text file without any issues but when i using special characters xml cannot parse special characters (&,- etc) error getting on my macro page. Anyone have any ideas on how to resolve this? Dim XDoc1 As Object Dim XHTML1 As IHTMLElement Dim XURL1 As String Dim CustomerName1 As String Set XDoc1 = CreateObject("MSXML2.DOMDocument") XDoc1.async = False: XDoc1.validateOnParse = False XDoc1.Load ("http://www.beamon.com/windows_application/macro1.php" + "?Id=" + Sheets(1).Range("D2")) Set Lists = XDoc1.DocumentElement Set getFirstChild = Lists.FirstChild Set …

Member Avatar
Member Avatar
+0 forum 1

Hello Guys, I am working on a Movie Platform and using XML file to upload/Publish Movies on to the platform. So for each Movie title I have to Edit and create an XML which is very time consuming and to be honest stupid. I want your help to suggest me a way how can I integrate this XML at the back of Excel Sheet and Index those fields which I have to change using Excel columns and can generate the XML file. I have data in excel sheet column wise. So each column serves as the data to be inserted …

Member Avatar
Member Avatar
+0 forum 1

Hi so i'm working on a project in c#. I have hundreds of xml files and I need to extract 6 values from each of the xml files and somehow display them on an excel datasheet. Here is an example of the xml file: [code] <XAxisCalib> <Max>288.93</Max> <Min>-48.08</Min> <MaxS>200</MaxS> <DfTHt>0</DfTHt> <LdVe>0</LdVe> <EjVe>0</EjVe> </XAxisCalib> <YAxisCalib> <Max>646.01</Max> <Min>-90.9</Min> <MaxS>200</MaxS> <DfTHt>0</DfTHt> <LdVe>0</LdVe> <EjVe>0</EjVe> </YAxisCalib> <ZAxisCalib> <Max>16.1</Max> <Min>-146.82</Min> [/code] I need to extract the <Max> and <Min> value of the x,y,and z calib. How can I do this. I've done tons of research but no examples show some of the xml file all sources …

Member Avatar
Member Avatar
+0 forum 3

Hi, I want to convert an XML containing images into Excel sheet. But it is displaying only image path, not image. How to display the image in Excel... ?? Can i use base64 encoding and decoding for this ? Please help...

Member Avatar
Member Avatar
+0 forum 2

The End.