• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

macro that no longer works as before.

S

stefanoste78

Member
Good evening.
The macro that I attached, once, perfectly extracted the google results, indicated in column A. Now it seems that it no longer works as before.
You will notice, opening the file, the results extracted long ago (which are the saved ones) and the difference when you start the macro.
Could you return it as before?
Thank you
 

Attachments

  • Nebu Google 5 first -1 (2).xlsb
    29.1 KB · Views: 14
For what it is worth, I commented out the following line and the macro works here, returning one line of data :

Code: 
With CreateObject("InternetExplorer.Application")
        'On Error GoTo Fin
'        .Visible = True
 
Thank you for your intervention. Monday I'll try the macro. I don't understand why but on the home PC with windows vista and office 2010 I can't get the macros to work.
I didn't read the literal translation done with google translator well.
Do I just have to remove the lines you indicated from the code?
 
in column c I have indicated the number of results for each line.
Is it possible to modify the macro in such a way that the number of results varies according to the number indicated?
Thank you
 
Logit said:
For what it is worth, I commented out the following line and the macro works here, returning one line of data :

Code: 
With CreateObject("InternetExplorer.Application")
        'On Error GoTo Fin
'        .Visible = True
Click to expand...

Good morning.
I tried the macro eliminating the lines indicated but it doesn't work.
the following message compiles error: Reference invalid or not qualified.
If I click on the question mark, this web page opens:
docs.microsoft.com

Invalid or unqualified reference

Office VBA reference topic
docs.microsoft.com
 
You must log in or register to reply here.
Back
Top