xml

I am using JotForms for data collection of names addresses and a short response. I am able to export those responses to a CSV or XLSX. I need to be able to take the responses exported and import it to a Fillable PDF form that was created. I was thinking the only way to do this easily is using an...

Hello. I am trying to build a macro to import data from an external file that is generated with another program. I have two options for my source file; an .xml file and a .txt file. Both contain essentially the same data that I want to manipulate into my end product. My plan is to be able to...

Hello everyone, I wanted a small separator to appear between buttons in custom ribbon tab. But the "<separator id="MySeparatorE1" />" always draws large vertical separator. How can we get small separator as circled in picture to appear between the buttons ? </group> <group...

Hi all, I currently use VBA to extract the 'overview polyline' returned from the Google Directions API, and paste it into a spreadsheet. However, I need more accurate polylines. I can get better accuracy if I can stitch together the child node polylines within each step. How do I convert my...

Hey! I have excel .xlsx workbook with loaded xml source. I take one row from sheet "Clients" and copy it to row "Data", then export is as XML with name changed according the data from the copied row and then use it in other ways. I have found one VBA in this forum that helped me solve the...

Hello, I am learning how to create and work with a custom ribbon in Excel 2019, but clearly have much to learn. I am running Windows 10. I created the XML and callback functions from examples I've seen on various Excel websites. I am not trying to create an add-in. When I open the Excel...

Is there anyway to have data be imported into an XML map vertically, rather than horizontally. Currently, the data is imported into rows, however, I need it to be imported into columns. The data can be anywhere from a couple rows/columns to over a thousand rows/columns. Is there anything...

Hi, I am new to using macros. I use xml mapped excel to extract flight planning information. However, when I send the excel and xml files through email to other users, the mapping link does not work obviously. Is there any way so that when these files are loaded on a new machine, the updated...

Hello, I am new to VBA and wanted to see if it is possible given a excel file with a sheet of data in it, and using VBA create an xml file? Is there ways or places to look at to get an idea/starting point? New to VBA and creating XML files. Is there a format used with the code, any tips would i...

I literally am using a tutorial found on w3schools.com on XML, I imported an XSX found on: XML Schema Example The schema is: <?xml version="1.0" encoding="UTF-8" ?> <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"> <xs:simpleType name="stringtype"> <xs:restriction...

Hi guys, I want use an organization chart (smart art) dynamically. I want use cells as data for chart but my data may change by level and count. so convert to shape is not fit for my situation. is there any way to do it? such as make change in xml file and so on regards

This is part of my xml I can map everything just fine except <Lost_agreement /> After i export mapped XML, <Lost_agreement /> is missing. it becomes But <Lost_agreement /> part is crucial and must be. How can i achieve it? Quote Reply Report

This is part of my xml I can map everything just fine except <Lost_agreement /> After i export mapped XML, <Lost_agreement /> is missing. it becomes But <Lost_agreement /> part is crucial and must be. How can i achieve it?

Hi guys. hope someone can assist me with this. my supplier provide me with an XML file containing all the available products which is updated weekly. the xml file contains a column titled Vendor code. now this is where it gets tricky, in order for me to get the images for a particular product i...

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

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

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

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

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

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