xml

Hi I'm trying to scrape an webpage. Dim html As HTMLDocument Dim oHttp As MSXML2.XMLHTTP60 oHttp.Open "GET", o.url, False oHttp.send Set html = New HTMLDocument Set html.body.innerHTML = oHttp.responseText Compile...

I have 82 XML files each named with a 3- or 4-letter code; each XML contains a field (or tag? I'm new to XML) called OBJECTIVE followed by text and a field called STRATEGY followed by text. ex) ABC.xml contains CODE ="ABC" OBJECTIVE [The objective is to win.] /OBJECTIVE INVESTMENTSTRATEGY...

Hi dear members, I just thought I would share with you here this very small and simple vba function that I recently wrote for switching ribbon tabs. Option Explicit Function ActivateRibbonTab(ByVal TabName As String) As Boolean Const CHILDID_SELF = 0&, NAVDIR_FIRSTCHILD = 7&, NAVDIR_NEXT...

Hello, I am very new to VBA, but when I get an example to run off of, I can learn that way. I've found another post on this website to be helpful, but I am running into a few issues. https://www.mrexcel.com/forum/excel-questions/593439-convert-each-row-spreadsheet-into-txt-xml-file.html Goal...

I am being tasked with extracting various strings from a massive XML feed and putting the extracted text into an excel template. The challenges: This XML feed is 1.5 million characters long. I'm not sure if VBA can handle this. I think the string variable has a cap? I can open the XML...

Hii.. Im working on a personal project where I need to import an XML(several) file to Access. I play a game called War-hammer 40k that has about 14 different armies, each army with 70+ units, each unit with different stats. There is an open source platform with all of the data in XML with .cat...

Hi guys, I spent considerable amount of time today searching for an answer and didn't find anything so I thought that someone here might be able to help (I often look for solutions here but didn't create an account till now). I'm responsible for developing and supporting some macros at work...

How to get data form pubmed with the help of PMCID using macros and VBA from xml? for eg. i want extract the data (title and abstract) from pubmed using the following link https://www.ncbi.nlm.nih.gov/pubmed/PMC29465225

Hello, I'm experiencing a problem with export of XML data from a mapped spreadsheet (MO 2016). Every values that are mapped as per *.xsd file are correctly compiled into a xml file. Unfortunately, the values of attributes that are in *.xsd file set to be fixed do not show up in the resulted...

Hi, I'm looking for a way to parse a REST API in JSON format without any external modules (like from GitHub). Similar to libraries "Microsoft WinHTTP Services, version 5.1" or "Microsoft XML, v6.0" to parse an XML response, what library contains methods to parse JSON format? And what would be a...

Hello, First, thank you for any help given. Second, I am just starting to get my feet wet with VBA and XML, so please excuse the misused terms. I would like have a script that loops through to increment a value within a URL and then download that XML to save to specified folder. I have seen...

Hi, Is there a code to add a title to right click menu and/or submenu without the use of xml?

As a long time member of MrExcel, I'm hoping all the Aladin Akyurek genius-types of folks can provide some desperately needed help -- I've been searching for weeks and not finding a *single soul* that knows anything on this topic or it's Excel functionality which seems shocking!?! With client...

I’m trying to compile data from multiple XML files into 1 Excel file with the data separated by tabs. Each tab in the Excel file would represent 1 XML file. How to I set that up? In the current setup, every time I import a XML file, regardless of which tab I’m working in, the data overrides all...

Hello, I'm just getting started with understanding the process of importing external information from an XML file into Excel. I'm working with some older files that were created several years ago. I was wondering what the best approach is to determine what source XML file the import process is...

Hi Does anyone know if VBA can read an XML text string and every time it hits a less than symbol "<" to moves it down a line (carriage return) I know I can get a XML line by line converter via Notepad++, which is great but I'm trying to remove this step from a process when converting some data...

It seems I can't find a straight answer anywhere, so I hope someone here is able to answer my question, or at least guide me in the right direction. I'd like to know if there's a way to import specific data from an online source, such as a json or xml file, have it automatically populate the...

Hi board! I want to get a text under span class = "black" from that website (its date and time of auction end): https://auction.violity.com/63039365-kollekciya-shkatulok-13sht Haven`t found any example except getting table content, but can`t handle even html-file opening :( Sub Web_Test() Dim...

I have multiple .xml files in a folder and I need to place them in an Excel worksheet one on top of the other. So far with the code below, it works to extract the first file, but when trying to extract the next file, I get the error... Sub LoopThruFolder() Dim MyFile As String Dim...