xml conversion

Hello Gurus, Hope your staying safe, posting after long time. so I have a sheet with table that contains Level, XML tag and Value in Column A, B and C respectively as shown below in Sheet named as "Master" LEVEL (COLUMN A) XML TAG (COLUMN B) VALUE (COLUMN C) 1 <AppHdr> 2 <Fr> 3...

Hi, I am currently seeking a solution to extract certain information from XML between tags, name, address, gender etc. Basically I need to be able to make information presentable in a table form. I have used the below formula which works to extract the problem is if i create a template to...

hi all, I have an xml file that I would like to edit in xml and then put back on our system. It's a config file that I can just pull off one of our servers, convert it from basically a text file, although it technically has an ".xml" extension., into an XML table, make the changes and then...

Hi, I want to create a XML file in excel. I have created the schema in excel in the correct syntax needed for the XML file. I have my date in column B - Z - column A has some static elements which will be used within the schema. I want to paste my data which will vary in to columns B-Z and...

Hi all I’ve inherited an old excel file from a colleague that I need to modify. My problem is that the file contains old XML-code and I need to convert this to VBA and I know next to nothing about neither XML nor VBA! I have one sheet (Sheet1) with data that changes each month. In cell B5...

Hi All Any suggestions for how to convert to XML lists in office for mac 2011? Thanks!

Hi, Excel 2007 on Windows 7. I have a couple thousand .xml files. A.xml,. B.xml, C.xml etc etc I simply need them to be .xlsx files. It's as simple as (1) Open the file (2)Convert to .xlsx (manually clicking the Convert button under the Save button on the Office button ribbon) (3) Close...