xml

I have an XML file (or web page if preferred) with the following: <?xml version='1.0' standalone='yes'?> <lrn tn='12345678901'> <LRN>12345678901</LRN> <OCN>004F</OCN> <LATA>552</LATA> <CITY>DALLAS</CITY> <RC>DALLAS</RC> <STATE>TX</STATE> <JURISDICTION>INTRASTATE</JURISDICTION>...

Hello - Really need some help here. I received chat logs in XML format and all the information is contained in a single excel sheet output. Transcript is extracted to single line XML. Here is an example of what I want to remove and don't know how: Jane.Smith@gmail.com -> How do I insert a...

Hi, Can anyone help me with generating a simple XML file from a table in Excel sheet? I can do this using the add-in if it was a regular table with simple rows and columns. But in my case, it's a tweaked table with merged cells. Is there a macro which I can use? I have attached a sample Excel...

Hi, I have created an XML map to pull RSS feeds onto my spreadsheet. However, when I refresh the table, it overwrites the existing data. I don't want the older feeds to be overwritten. I would like to keep a track of all the feeds coming in over time. How do I avoid overwriting? I'm using...

Anyone How to to display the Following in XML with Following <co name=""><add1><add2><PHP> <a1><b1><city><Header>Co Name</Header> <Address>Add1</Address> <Address>Add2</Address> <A1> <B1> <customer>ABC Co</customer> <address>123 Main</address> <city>Salem</city> </B1>...

I'm using SAP BEx Broadcaster to routinely send SAP reports via email (and concurrently adding to team-space). The output format is listed as "XML (MS Excel)" format. It is sent via email attachment with "xls" extension and older style excel icon. When opened directly from excel (ie 2016) an...

Hi, I am trying to write a macro to load an XML file to memory and then walk through its various nodes and perform some actions. However, the XML documents that my macro is supposed to read contains a reference to an external DTD and each time when I run my code, I am getting the following...

I'm running Excel 2013 on Windows 7. In one of our workbooks I found I could not access the 'get external data' controls - all are greyed out. I checked and this seems related to the import of an xml file, exported from SSMS 2016. In a new workbook, selecting Data / GED / ../XML Data Import...

Good Morning, Thanks to the help of this board and google, I have been able to write the below macro in excel: Sub GetFormData() Dim XDoc As MSXML2.DOMDocument Dim xEmpDetails As MSXML2.IXMLDOMNode Dim xEmployee As MSXML2.IXMLDOMNode Dim xChild As...

I created an addin that works fine. I wrote a bunch of code and assigned them to buttons. But I would like to add some buttons using built in functions like Add Row, Delete Row, Hide Row. How do I refer to these built in commands? Here is a line of my XML code: <tbody> <button...

Hello, can you someone please help me with this XML code? Attached is what the report looks like. I need help removing the waterfall subtotal, remove the subtotal in row 3 and 4. Fill down column A and B. Is that possible? Thank you in advance! Here's the current report definition in the tool...

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...

Is there a way of posting xml code on this forum without it disappearing ? Thank you.

This is probably a long shot. I am a huge fan of The Sims 4 and I would like to start modding for it. But all of the programs people use to extract the XML data to create the mods are made for Windows... and, you guessed it, I have a Mac. I have asked in multiple TS4 forums if there is program...

Hey. Im having an issue with a SUMPRODUCT forumla that i just cant get to work. i have no real skills in Excel (working on excel 2010) and everything i write comes from alot of googling and trial and error. Usually i can find the answer after some time looking. But today i spent half the day...

Dear Excel Giants. I have got a problem at hand that needs immidiate attention. and need your help. Our new data base is missin "Description" field from old database. But we cannot directly acess new database we are only allowed to update it using XML file. * So we have extracted excel from...

HI All. I am getting belowerror while converting XML file to excel. 1) Con-Ledger-2015-03-31.xml 2) Std-Ledger-2015-03-31.xml I have 2 files in a folder I am able to convert the firstfile were as 2nd file shows the below error. The xml file cannot be opened because of error...

Hi! Running an Excel 2016 workbook with a few data connections to SQL server and they refresh fine with "Refresh all" command. I added a XML-mapped table just for exporting (i.e. no real refreshing needed - data in XML-mapped table is filled manually and via formulae & exported on-demand). Did...

I need to get the data which is always changing to my mdb or accdb and the data is an XML in form of weblink. I need to make it dynamic meaning when I make query access would goto this link and get the data. Excel 2016 can do this but how do we do this in Excel ? Thanks

Hi, I am working on the excel project where I my client wants to run macro on pre existing commands of Excel... So I am using UI editor to execute that task and my xml code working on buttons controls not in (toggleButton, checkBox, comboBox, splitButton, dropDown) controls, This is my xml code...