VBA to return Web-based XML document contents as a string.

**joeyslaptop** · 09-12-2021, 01:12 AM

I have been working my entire Saturday at this. Mostly, I tried to create xml Schema maps and all kinds of stuff. I don't think it needs to be that complex. So, i took it back to the basics.

In VBA, I used cell contents to help formulate a URL. The URL opens in IE, and the page that loads is a simple, tine XML document. I need to return the contents of that page (which is an xml document) as a string to VBA.

Otherwise, I need an easy, comprehendible way to do a Web call to ask for the data and return it as a string.

Here is what I have so

HTML Code:

**Keebellah** · 09-12-2021, 02:45 AM

I can go to long ways of explaining it but since you already have vba code, read up on this one and you'll gte the idea.
Just remove all non essential html tags from the retrieved cod
https://www.encodedna.com/excel/extr...-using-vba.htm
Happy coding

**joeyslaptop** · 09-13-2021, 11:42 AM

I might not be advanced enough to use that code. VBA doesn't recognize terms like "HTMLDocument". I might be missing something. I tried dimming it as an object instead. But I still encounter issues when I get to the part where it's supposed to retrieve the contents of the file.

I think this is basically a Web call. I submit the URL, and the page that loads is an XML document containing the results. I don't care if it has tags, etc. I just want to be able to return all of the resulting plain text to a cell.

**joeyslaptop** · 09-13-2021, 01:51 PM

Update: I didn't realize you have to install/activate additional Libraries in order for it to recognize the terminology.

**Keebellah** · 09-16-2021, 03:30 PM

Yep, many functions and references are library dependant
For each application there are separate libraries which ned to be referenced for VBA code to work properly
I was away for the past days, how have you fared so far?

VBA to return Web-based XML document contents as a string.

LinkBack

Thread Tools

Rate This Thread

Display

VBA to return Web-based XML document contents as a string.

Re: VBA to return Web-based XML document contents as a string.

Re: VBA to return Web-based XML document contents as a string.

Re: VBA to return Web-based XML document contents as a string.

Re: VBA to return Web-based XML document contents as a string.

Thread Information

Users Browsing this Thread

Similar Threads

Find a text string and return that cells contents plus adjacent cell contents

[SOLVED] Extract data based on text string contents + organizing results

[SOLVED] Formula to return a cell's contents from a different row based on another cell's contents

Find string: if 2 hits in document -> then write to a new document path of that doc.

Return contents of cells that contain a character string.

Return pictures based on cell contents

[SOLVED] IF range of cells contains string of text, return contents of cell where string is found

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions