1. J

    Parsing a text file

    I have an xml file that is about 80MB. I constantly have to import it in excel and do filtering in it. Sadly, it takes too long to open and sometimes crash. So I have decided to manually break it down into pieces. My steps are usually: 1-Use a software that split the files into multiple...
  2. M

    Export XML Map with VBA

    I have an XML Map that is mapped to a Sheet in Excel. I always exported it through Developer - Export, wrote the filename, clicked through the folders and exported it. I'm trying to make my life a bit easier and wanted to create a button on the Sheet, that would trigger the Export dialog...
  3. nardagus

    How to extract XML attachment from PDF

    Hello All, Recently I have received some PDF files with XML attached. Of course when I double click on it it will open in a text editor. Cool. However. What I need to do is: 1) Open PDF 2) Extract XML attachment 3) Import it to a worksheet 4) Close PDF 5) Open another PDF 6) Extract XML...
  4. J

    Split large xml files into multiple

    I am working with a large xml files that is about 80000KB and it's full of data. It's bigger that the maximum allowed in excel. So When I try to import it as a table in excel I get an error. I am looking for alternatives on how to import the data in excel. I am thinking it may be best to split...
  5. E

    Lock button in Powerpoint Custom Ribbon

    Problem: I have a lock button (toggle button) on my custom ribbon. Basically "lock and unlock" the "Aspect ratio" of the text box. Also i wanted few points to cover while preparing it - - I wanted to run the event on powerpoint, whenever I select the single or multiple text...
  6. R

    Import XML via VBA

    I am trying to modify a filedialog I currently use to import xml files. I would like to change from the folder selection to individual file selection, but I cannot seem to get it to work for me. If possible could somebody please help me? Or point me in the right direction. Thank you. Sub...
  7. J

    Xml to Excel with VBA

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

    Create xml for each row for excel file

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

    Convert HTML doc to XML for xPath Parsing

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

    XML table / conditional TEXTJOIN function

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

    Get Array from XML web page using VBA

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

    Access from XML/XSD

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

    XML Import Confussion

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

    http elements xml

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

    Macro to edit styles.xml file of workbook

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

    Have trouble transposing XML Data

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

    Converting single row in excel to XML document using VBA

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

    Loop through folder to import cell from each file.

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

    How can i add button to `ContextMenuShape`?

    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"...
  20. H

    XML Format Issue

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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back