xml

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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.
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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.
  12. 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...
  13. 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>...
  14. 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...
  15. 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...
  16. 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"...
  17. 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>...
  18. J

    Convert XML Files to Excel

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

    XML Map autoexpansion issue

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

    Vlookup - display previous value if zero

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

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top