html

Hi, Long time fan, first time poster. Also this is my first attempt at manipulating web stuff, so apologies if any phrasing is misleading. I am entering data on a website (to autoamte a data scrape). There are 4 fields: - Post Code (Text box) - Occupancy (Drop down) - Building Type (Drop down -...

I'm trying to use VBA for web scrapping (★ Dream Catcher Home Stay, Cochin, India) and get numerical value for "b_hotel_id" line in the code below <td class="line-number" value="568"></td> <td class="line-content">b_hotel_id: '554615',</td> but I don't know how to refer to it, as there is no...

I need to copy the Table of content from a webpage and paste it to excel with correct indentation. Now, my current process is, copying the content from webpage and pasting it to an excel and then select the column and run the below script, This script will placed arrange the content in...

First off thanks to everyone on this forum for your help. I have learned a ton and am able to create a process for my org that is going to save everyone a ton of hours. I will be excited to share with everyone once it is done. So the code below is supposed to reference a named range "_FileLoc"...

**Definitely a beginner. Please bear with me. First attempt at web scrapping.** I need the following URL to auto-login and retrieve a table from the website. I have pieced together VBA code from different websites to fill in the login information and hopefully pull a table but I am unable to...

Hello, how would I count the unique in a range like this and extract them in to a vertical list please...? Excel WorkbookBCDE2Plum3PlumWatermelonApplePeach4MelonKiwifruitBlackberry5RaspberryBlueberryCranberryBananaSheet1

Is it possible to export a table with filtering capabilities? I know it's possible to get formatting, but I cannot figure out if filtering is possible.

The code below -- created w/ help from this forum -- does a great job of cycling through a list of ~300 URLs (listed starting in cell A2 of sheet "URLs") and importing the table data from each into sheet "MXquote", pasting each chunk of table data on the first available row, such that the end...

I have a local .aspx file that I generated by downloading from an HTML web page (the browser extension saves it as .aspx...not entirely sure why.) It contains a few hundred tables that I want to import into Excel, but my googling suggested that only Excel versions 2010 and later have a native...

Hello. In cell A1 I'm receiving Customer names an their home town in form of huge HTML code. I need to extract Customer names in column A (A3:A600) and their home towns in column B (B3:B600). Part of HTML code for names is always the same: <div class="customName--1gBeC">J. Jones</div> Part...

I have used Excel VBA to navigate to a web site. I am trying to pull data from a specific part of the website. When I inspect the element the following is displayed: <span id="Status">Ready to Drop Ship</span> Does anyone know how to get the data "Ready to Drop Ship" from the above HTML code...

hi, Is there any good add-on for scraping html? VBA is too hard to work with.

Hi all, I am trying to separate string from a cell based on character present and add it after to HTML body. Sample text (all in one cell): <tbody> Need to separate it by ";" and add it to HTML body for better look, like this: Think this is somewhat common problem, but can not find a...

Hello. In cell A1 (Sheet 1) I'm receiving a huge HTML code. I need to extract somehow values for 'top' and 'left' without % suffix. for: style="top: 54%; left: 13%; I need only 54 and 13 Results should be placed in column B for top values (B2:B300) and column C for left values (C2:C300)...

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

Trying to pull the piece in bold below in the HTML for the following URL: https://www.tesco.com/groceries/en-GB/shop/fresh-food/all?include-children=true&page=1 <div class="tile-content" id="tile-253558119" data-auto-id="253558119"><div class="product-tile-actions--has-no-text"></div><a...

Hello, Trying to pull all the names of the items and then the price on this page, https://www.tesco.com/groceries/en-GB/shop/fresh-food/all?include-children=true&page=1 e.g. Tesco British Salted Block Butter 250G £1.50 Tesco Gala Apple Minimum 5 Pack £1.60 But the code fails on this line...

Hi, Can someone derive formulas for I3:I8? Thanks Excel WorkbookBCDEFGHI1Table 1Table 2Table 32CodePriceCodePriceCodePrice3X1$ 2.00Y1$ 1.00X14X2$ 4.00Y2$ 3.00X25X3$ 6.00Y3$ 5.00X36Y17Y28Y3Sheet1

Hi, I am writing the following code which allows me to proceed to a website that I need to gather info from to then export into excel. I am very new to HTML web scraping with VBA and I am currently writing it line by line and testing it as I go. Sub GoToMarketingScents() 'navigate to...

I am trying to use the Mr. Excel HTML Maker and either I am doing something wrong or I don't understand what I'm supposed to do. I downloaded the file, unblocked it, selected the Add In, went to my workbook tab and selected the cells I want a screenshot of, then clicked the User Defined...