1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. 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...

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

Automate the actions of searching and saving the results of a scrapping program with the use of a ma

Discussion in 'VBA Macros' started by stefanoste78, Mar 3, 2018.

  1. stefanoste78

    stefanoste78 Member

    Messages:
    91
    Good evening.

    I found a program to extract contacts from google maps.

    When I start the program it automatically opens a page of google maps where I enter the search key and then start the program. This program extracts the data for each google maps search page.At the end of the procedure it is possible to extract the contacts in the excel format.To repeat the procedure it is necessary to re-enter a search key, etc.

    Could you help me to automate the procedure for entering the search key, automatically starting and extracting the excel file generated in a folder on the PC with a macro?

    To make the program work, it is necessary that the browser language is in English and to start it just click on the icon in the folder with this name: Google Maps Crawler Pro.

    I would like to insert the search keys in the "to" column of an excel file and insert the files extracted from the search (with the same name of the search key) in a folder on the desktop called "search results".

    https://www.dropbox.com/s/uszy1ky9fkg6oro/Google Maps Crawler Pro.zip?dl=0

    Thank you
    Last edited: Mar 3, 2018
  2. stefanoste78

    stefanoste78 Member

    Messages:
    91
    Is there someone who can help me? Thank you
  3. Marc L

    Marc L Excel Ninja

    Messages:
    3,899
  4. stefanoste78

    stefanoste78 Member

    Messages:
    91
    hi Macr L. Is it difficult to make the macro I need?
  5. Marc L

    Marc L Excel Ninja

    Messages:
    3,899
    stepano,
    maybe yes, maybe no, as I do not use browser in English …

    At least just activate Macro recorder and operate manually :
    you will get a base of code !
    ______________________________________________________
    If you can’t explain it simply, you don’t understand it well enough … (Albert Einstein)
  6. stefanoste78

    stefanoste78 Member

    Messages:
    91
    I tried to use the macro record but I do not think it worked.
    This would be the code:

    Code (vb):
    Sub keywords()
    '
    ' keywords Macro
    '

    '
       Range("A2").Select
        Selection.Copy
        Range("A3").Select
        Application.CutCopyMode = False
        Selection.Copy
    End Sub
     
  7. stefanoste78

    stefanoste78 Member

    Messages:
    91
    Hello guys.
    Could you just tell me if with a macro it is possible to automate some actions that are normally done with the mouse and the enter key?
    If it's possible I'll look for a solution elsewhere ...
    You only need to copy the search keys from a file and insert them on a program (by clicking on a program key) and then start it and download the file that the same generates cliccanso on another key.
    Thank you
  8. Marc L

    Marc L Excel Ninja

    Messages:
    3,899
    It depends, sometimes it's easy, sometimes not …
    Better is to directly ask to the author of the tool.

    As in VBA you can develop your own code
    without the need of an external tool,
    see the samples everywhere on the Web …
    Or use an automation tool.
  9. stefanoste78

    stefanoste78 Member

    Messages:
    91
    can the macros be used as an automation tool for operations that are performed with the mouse / keyboard without necessarily having to interact with the program code?
  10. Marc L

    Marc L Excel Ninja

    Messages:
    3,899

    As macros died 20 years ago (‼ Almost only for cells)
    a VBA code must work directly with objects …​
  11. stefanoste78

    stefanoste78 Member

    Messages:
    91
    So in substance it is not possible to do anything about the program.
  12. Marc L

    Marc L Excel Ninja

    Messages:
    3,899

    As I yet wrote : maybe yes, maybe not as I can't test
    and as you do not ever try to write any code …
    Better is to see directly with its author or see any automation tool …
  13. stefanoste78

    stefanoste78 Member

    Messages:
    91
    You're right, however, it is not for me to create macro.
    However it would be enough to change the language of chrome in American English (it is easier to create a macro) :)

Share This Page