+ Reply to Thread
Results 1 to 7 of 7

Web-crawler looking for keywirds

  1. #1
    Registered User
    Join Date
    03-25-2012
    Location
    New Jersey
    MS-Off Ver
    Excel 2016
    Posts
    98

    Web-crawler looking for keywirds

    Hi Back in 2015 you folks helped me with the original setup of this, it was on post4247489. It worked fine for a few years but now I am getting a VBA error and I cant figure out whats wrong. Our company had us using a much older version of IE back then and now they have standardized on IE11 if that matters. If anyone can help me where it "sticks" i'd greatly appreciate it. Please see attached and press the button called Check in cell G1

    Thank you,

    Dave
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    03-25-2012
    Location
    New Jersey
    MS-Off Ver
    Excel 2016
    Posts
    98

    Re: Web-crawler looking for keywirds

    Anyone? The VBA code now fails at a point it never did before? Any help would be appreciated please.

    Dave

  3. #3
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,057

    Re: Web-crawler looking for keywirds

    I usually use late binding rather than early... and also rarely use the InternetExplorerMedium approach.. Try this modification, seems to work on my end (2 lines changed, they are in red):

    Please Login or Register  to view this content.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  4. #4
    Registered User
    Join Date
    03-25-2012
    Location
    New Jersey
    MS-Off Ver
    Excel 2016
    Posts
    98

    Re: Web-crawler looking for keywirds

    Arkadi, thank you. that did the trick. odd how it worked for a few years then stopped. The binding and IE approach you mention, is this something your two changes fixed? I'm open to any and all improvements from what I am using... Thank you for your help and time!!!

    Dave

  5. #5
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,057

    Re: Web-crawler looking for keywirds

    The late binding is more convenient because you don't need to add a reference library when using late binding. The downside is that during coding you don't get Intellisense help.

    I suspect that if you used "Dim ie as InternetExplorer" it would also work... because my version is the equivalent of that.

    I'm glad it worked out for you, and thanks for the rep
    Could you also please mark the thread as solved if you are satisfied? Thanks in advance.
    Last edited by Arkadi; 12-06-2018 at 03:58 PM.

  6. #6
    Registered User
    Join Date
    03-25-2012
    Location
    New Jersey
    MS-Off Ver
    Excel 2016
    Posts
    98

    Re: Web-crawler looking for keywirds

    Thank you again, I will close it now. I was waiting in case you replied. Thanks!!

  7. #7
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,057

    Re: Web-crawler looking for keywirds

    My pleasure, and happy coding

+ 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. web page crawler ( web to excel)
    By saurabhlotankar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-02-2017, 07:25 AM
  2. Macro VBA Web Crawler
    By nocturne07 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-11-2016, 05:35 PM
  3. Can I create excel based web crawler
    By chiragparekh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-24-2013, 08:13 AM
  4. Web Crawler to dowload PDFs
    By abousetta in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2013, 11:23 PM
  5. web crawler
    By owl527 in forum Excel General
    Replies: 5
    Last Post: 11-24-2005, 11:12 PM

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