+ Reply to Thread
Results 1 to 3 of 3

how to import html code with no name into worksheet cell?

  1. #1
    Registered User
    Join Date
    08-03-2015
    Location
    Iceland
    MS-Off Ver
    0002
    Posts
    17

    how to import html code with no name into worksheet cell?

    http://easypronunciation.com/en/fren...tion-converter
    Where can I import the sum written below the text box so I can create code for the excel sheet. I tried to do so by recording a macro, but excel wouldn't import the web page.


    Please Login or Register  to view this content.

    Also where is the best resource on web-scraping (syntax, how it works thoroughly) with VBA and excel?

  2. #2
    Forum Expert JasperD's Avatar
    Join Date
    05-07-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    1,393

    Re: how to import html code with no name into worksheet cell?

    Use the code below - the captcha result will be stored in variable 'calc'.
    Please set reference to Microsoft HTML Object Library (tools -> references).

    Please Login or Register  to view this content.
    Please click the * below if this helps

  3. #3
    Registered User
    Join Date
    08-03-2015
    Location
    Iceland
    MS-Off Ver
    0002
    Posts
    17

    Re: how to import html code with no name into worksheet cell?

    Thanks for the response, but the code doesn't work for me. I am using Excel 2007. It would be appreciated if you could include the calculation in the code, as the calculation is unique for each time the browser is opened. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA to Import HTML Table Locally Stored HTML file to excel
    By ermengard in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-09-2015, 10:48 AM
  2. Import/pull data from html code into excel
    By emoandy05 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-13-2012, 01:39 PM
  3. Import html from website into cell possible?
    By datacruncher in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-25-2010, 10:52 AM
  4. How to paste HTML code as text into a worksheet?
    By c mateland in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-20-2006, 07:30 AM
  5. Import HTML code into Excel
    By josuegm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-30-2006, 06:10 PM
  6. Import HTML code from a text file.
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-01-2005, 03:06 AM
  7. Can I import raw HTML source code into Excel?
    By J Diorio in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-17-2005, 01:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1