1. G

    Paragraphs in one Cell > HTML

    Hello, am trying to convert an excel file to HTML. I have a few 100s of rows. Serial No. Name Composition 1 Destadine Syrup Each ml contains: Desratadine BP …….. 0.5 mg In a flavoured syrup base 2 Chlorphamine Each ml contains: Frech BP …….. 0.5 mg In a flavoured syrup base...
  2. J

    Webscraping Grocery Website

    Hi There, I'm having a lot of trouble trying to get a simple webscrape to work. I am using a dynamic URL to search for a product (in this case 'GREENE KING ABBOT ALE') and what I'd like to do is have all the available links that return from the site to appear in column A of sheet called 'Single'...
  3. H

    excel to html

    hi dears i have excel with 10 sheets and i need vba for convert to 1-html format and 2-csv comma utf8 and 3.txt format 1-do it for entire workbook automatically and with no question 2-for each sheet make seperate file name and same as sheet name in my excel file path 3- printarea by default...
  4. D

    Scraping HTML Tables with VBA

    I am scraping HTML tables with a GET request. The req.responseText is then passed to the module below to process the HTML tables. My code works 100% but I'm trying to optimise it. It is a large daily crawl. I have 2 questions: 1. In the section where I'm processing the "className =...
  5. S

    Importing Image into Excel Worksheet With HTML Code Elements

    Hello, I'm looking to import a few images into my excel file and I plan on importing the picture by calling the pictures based on their html elements. The image html code: <img chart-id="2669" alt="Chart ID 2669" class="chart-img" src=""...
  6. G

    Excel export cell range to HTML via Macro

    Hi I have the following macro which exports my sheet (Page1) as an HMTL file and it works well, except it exports the entire page. I was wondering if it could be modified to export only a selection of cells on the page? such as A1:CN106? Sub HTML_File() With...
  7. A

    Will a kind soul help to provide a vba solution to insert text into webpage textbox

    Dear all, I am trying to input text into a webpage and search and am running into problems. Below is my code Sub GetHTMLDocument() Dim IE As New SHDocVw.InternetExplorer Dim HTMLDoc As MSHTML.HTMLDocument Dim HTMLInput As MSHTML.IHTMLElement IE.Visible = True...
  8. A

    Search for an item in a search box in a website.

    Hi I am new to this, i watched a few tutorials and tried out on my own and realize that i can't even do a search in the search box of the webpage. Below is my code that i tried. Sub Automate_IE_Load_Page() 'This will load a webpage in IE Dim i As Long Dim URL As String Dim IE As...
  9. S

    VBA: Working with Loops To Log into Website

    Hello, I'm having a hard time getting my vba code to work. What my code is doing is opening a website, entering the username and password and then I want it to click the login button. My current problem however is that I cannot get my code's loop to Click the Login button once my username and...
  10. khawarameer

    Converting HTML Code to Table in MS Word

    Dear All, I have an html code available in an excel column (Please refer below table). My aim is to send that code to Word Document using mail merge and convert the code in to a Table when it is merged in word document. However when excel column in merged in Word Document the html code is not...
  11. P

    Web scraping not working

    Trying my hand at web-scraping again. I want to grab a specific text from a website, and to do so the first part of my code dumps the website's response into a cell of the worksheet. Here is the code: Sub Test() Dim URL As String Dim HTTPObject, HTMLObject As Object URL =...
  12. S

    Excel VBA Load Data from HTML Website without CreateObject("InternetExplorer.Application")

    Hi all, i will load data from a html website. the problem is i can not use "CreateObject("InternetExplorer.Application")" because the site don't load in the internet explorer. In Firefox the side works. i need all data in the blue boxes from all 4 Areas i test it with...
  13. reasem

    Download PDF from URL in Excel VBA

    looking to download a PDF from a URL. I can't seem to get past the login screen as the pdf that is downloaded only contains the code for the login page if I open it in NotePad. I examined the post request after logging in manually and pasted it after "FormData." I'm not sure if it matters what I...
  14. U

    HTML Object Internet Explorer automation

    How do I select an option from a dropdown menu and update the webpage. Code: Dim IE As New SHDocVw.InternetExplorer Dim HTMLDoc As MSHTML.IHTMLDocument then I navigate to a URL and I fetch the dropdown menu using html id and put value=my desired value HTMLDoc.getElementById("xyz").Value =...
  15. A

    Convert row data in html table with 3 columns code

    Hello! I'm struggling with a task that is above my knowledge. I have a huge table like this example below: id html code model model model model model model 1.10.M1007 <tr><td>Asus M6 Serie</td><td>Asus M6000</td><td>Asus M6000 Serie</td></tr><tr><td>Asus M6000A</td><td>Asus...
  16. D

    HTML Through VBA - Trigger event on HTML Form

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

    How to get Value by VBA from Source code

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

    VBA Script to copy the content from webpage and paste in excel on with correct indent.

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

    1004 error on Array. Worksheet failed.

    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"...
  20. P

    VBA Wesite Login

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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back