xml

Newbie at best on anything really deep in the Excel world. Basic skills, watched a few YouTube videos. A separate application requires the use of XML mapping to function. This is something that cannot be changed. I have created a XML workbook that makes use of VLOOKUP and some calculation...

Hi everybody, I am new here so I I'll try posting this and hope someone can help me with this, since i know to little about vba coding. I have this excel sheet that I have made with two sheets, one of which is called data and the other input. One contains Data with different posts that have...

Hi Access Wizards, I have a MS Access 2010 Database that I use to import an XML file on a daily basis. The XML file is generated each morning via FTP and lands in the same folder as the Access database. Is it possible to have Access automatically pick up/import this file? The XML file name...

So somebody at my company has told me they would like a macro enabled Excel workbook that can connect to a certain Fortune 100 Electronics company's database system via API and extract customer requested information. A customer would be able to enter a quote # or some other UID and it will...

Does anyone know how to add a record to an xml file using an xslt file? This record should just be a copy of the previous row but with all its entries blank so that when I use ImportXML in VBA I get a sheet with data + one blank row at the bottom

I'm trying to edit an XML file with Excel 2013 (Office Pro) The source have the following 2 lines at the top: <!--?xml version="1.0" encoding="utf-8"?--> <arrayofsessiondata xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> I cannot find a way...

Hi I am new to reading XML files to Excel using VBA. I can load the XML file to Excel but when I try to put the data into a worksheet it puts the entire XML contents into a single cell. What I want is each line of XML in a row in the worksheet. An alternative is to open in notepad. I can open...

Hi all, in this thread we solved, how to read data from an XML file with VBA. Everything was working perfect, until the developer installed a patch for encoding :eeek: This is part of working version before the patch, it throws a strange error in .responseText Set XMLdoc =...

Hi Guys, I'm working on a data cleanse project at the minute where I'm trying to fill in as many gaps in our data as possible (around 30k records running at 53% blank fields - Dealing with about 6 years of data migrations and lazy employees not focused on data quality) One of our fields is...

Hi How do I post xml code as example, when I am posting VBA code example. I tried [code],

Hi. I've got a excel program that i want to add 2 buttons, to choose which language the user want to use, so much question is this: Is it possible to add text in a xml file, and when i press language button "x" or "y", it loads the xml file for the correct language, and imports all cell names...

Trying to pull the Manufacturing cost index from an XML pull. The XML comes from https://api.eve-industry.org/system-cost-index.xml?name=Osmon I successfully used the WEBSERVICE function in excel to create and pull the data; <CODE>B2 = Above Link, C2 = System name (i.e. Osmon)</CODE><CODE>...

I am trying to scrap video names and hyperlinks from one of the channels i have subscribed, the goal is to get all videos names on that page and create a hyperlink, below is the code that i have created and works so far, the problem i am facing is that it only fetches the data that is displayed...

Hello, I am trying to alter some code to download a reportas a csv instead of XML due to the size. The following code works as XML Reports/Operations/sales/MI/hier full&rs:format=xml I assumed I would just need to change the format=xml toformat=csv However I get an error stating “whitespace is...

Hello, I have a problem with the MSXML2.XMLHTTP object in VBA. I need to send a message in json but the auth token has double quotes in it. So in order for those double quotes to arrive in the message a backslash is used. Now by parsing the xml to Json the xmlhttp object adds an extra...

I've got a web page that I can send a generated URL and the page returns some XML that I then parse and insert into my spreadsheet. All of the URL creation and XML parsing works but there's a problem with trying to run this in the real world. The website requires that the user is logged in in...

If you receive a workbook where the document was created with an undesirable default Font/Size, what can be done to change it, other than editing the documents XML? Setting the Font/Size for headers is done under: File\Options\General... When creating new workbooks Make it a nightmare by...

G'day, I have a url for API call: eg: http://<api ip="" address="">User=<<IPADDRESS>>:123456&Type=XYZ currently i need to manually change values for those variable to see the status of those users. i get the response in XML. i have 1000 users and Type of users are PrIV or PER. for each of...

I've got a workbook I'm trying to modify the ribbon. I have an empty "test" workbook that I used to create the XML code using Ron de Bruin's and other's examples. The empty workbook's ribbon is exactly what I want. Now I copy the XML code into a the target workbook that has all the VBA and...

Really, I just can't believe that I constantly get the "Can't assign to array" error message... :( I can read an XML file easily and assign the node values to a collection but the same is not true for an array. I don't know why, I guess I need to read more about Collection vs Array differences...