xml

Hello, I've got a little problem with my project. I have to create a workbook with a table with a button to import a folder full of xml files(columns are all the same). My problem is that every xml file got a single table, so i cant work with them in a pivot chart or something else. This is the...

Respected sir / mam, i am looking for automation or macro to generate xml for each row please find attached excel file where date is paste and seperate .xml file which need to be generated seperate xml file & excel file path thanking you for valuable time & feedback.

I am trying to find a good way to convert an HTML document to XML so I can use an Xpath expression for parsing. As a test I'd like to get this xpath expression to pull information from What Is My IP❓ Shows your real public IP address - IPv4 - IPv6 //*[@id="post-7"]/div[1]/div[1]/div/ul/li[2] So...

Hi I have a system which exports XML files that I need to convert into Excel for reconciliation etc. The XML table function in Excel works but puts each bit of data on the next line - for example: Ref Surname Forename 1 Mouse Mickey 2 Duck...

Hello, I have this code: Dim xmlOBject As Object Set xmlOBject = CreateObject("MSXML2.DOMDocument.6.0") xmlOBject.async = False xmlOBject.Load ("https://www.boi.org.il/currency.xml")' just example URL and its load to the xmlOBject variable the XML resulte. Is there a way to convert a...

Hello, does anyone know if there is an easy way to import XML data and relationships into access? I am interested in working on a publicly available dataset (here: https://www.hesa.ac.uk/support/tools-and-downloads/unistats) but have only been able to import the xml tables - not the...

Hey all, First time poster here, but i've lurked on the site for a while. I'm looking to import an XML in to Excel but i'm having issues with it. I've used the Import wizard and feel like i'm most of the way, but i'm missing something probably simple. The XML is a few hundred records and has...

Hello, Getting confused with Div tags etc. Any guide for this? How do you pull a "$0" from html in VBA via XML? Thanks.

Hey pro-team! Our company has a problem with copying and pasting data dumps from our ERP system into workbooks over-and-over, resulting in compounding workbook styles to the point where multiple workbooks each month hit the excel style count max (~64,000), which causes workbook crashing and an...

Good day, I've having trouble transposing a bunch of XML bracket data horizontally. Data is like so <tbody> App a b c d /App App a c d e f /App </tbody> I need it to look like this <tbody> App a b c d /App App a c d e f /App </tbody>...

Hi All I am after some help I have been asked if I can convert a spreadsheet that will have a variable number of rows into single XML files for ordering here is a basic example of my data <tbody> Name Brand Quantity Unique Code Mr Why Generic Ale 2 XML00001 Mr Who Generic Lager 4...

I'm looking to create a macro that i can say look inside this folder and within each file found copy and paste a specific cell to a currently open workbook i have. I need the macro to paste the cell below the previous. The files that are being used are xml and so they need to be imported via...

This is duplicate! I have Microsoft Office 365 2019. How can i add some <code style="margin: 0px; padding: 1px 5px; border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console"...

Hi I have an excel macro that is creating an XML but it saving the XML file like this: <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <funds xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <fund> <id>123456</id> <name>Apple</name> <basis>F</basis> <type>Fruit</type>...

Hi Guys, Just wondering if anyone knows how I can convert XML files to EXCEL format easily? Thanks. Jay

I have 3 tables in Excel 2016 worksheet. Tables 1 and 3 are connected to SQL database and Table 2 has a XML Map to import and display XML-files. Created a simple mockup to better illustrate this. When loading data, each autoexpand fine and push header of the table beneath downwards to make...

Hello, I have an external connection pointing to an xml which display some values. Sheet1: Values Sheet2: External values I managed to do it with Vlookup but since the XML sometimes doesn't updates correctly and points to "zero" (since it can't read it from external source) I will want to...

Hi, I am trying to insert an rss feed from the web into Excel, but this seems to have stopped working ever since May 2019. The link I am trying to insert is: https://www.totaljobs.com/JobSearch/RSS.aspx?Keywords=Performing-arts&LTxt=Birmingham&Radius=10 The data appears correct when you...

Hello everybody! Like the title i need to do this task. I found this code on web that fits perfectly with my goal: <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family...

I have a linked table in a local Access (2010) database. This linked table contains a table that's connected to an XML file on the server. The reason why I have it set up this way is because from my understanding, Access does not have the ability to create a link to an XML file. In any case...