#xml

Hi all, I'm pulling xml data from a folder using Power Bi Desktop. When I have expanded all the columns in PowerQuery, I get the following error message when trying to apply the query changes. The changes could not be saved to the server. Error returned: 'OLE DB or ODBC error...

Hi, I want to export over 500 cells to separate .xml files. I wrote a macro in VB which is working (code below) but the exported text inside the exported .xml file is cut. The full text should have ~11500k characters and the exported one is ~8200 characters. I am missing the end part of the...

Can you help me on the below? I have 2 tables in Excel. (images) I want these tables to be exported in XML in a certain format (see code below). <?xml version="1.0" encoding="UTF-8"?> <cbc:CBC_OECD xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:stf="urn:oecd:ties:stf:v4"...

Hi guys, I need help with VBA for button to export .xml table by selection. I tried to copy and combine some example code but with no luck. It creates .xml but not for selection or fixed range (never mind) but the data is wrong as I don't know how to code it properly... The code is: Private...

Hi guys, I'm a noob in this area but I'm trying to make my daily job easier... To do so, I created an excel order page with some VLOOKUP and data validation dependent dropdown lists. I have a mess with internal codes and linking between codes so the purpose of this tool is to always return the...