anvesh1818
04-27-2020, 11:39 PM
okmark (https://www.mrexcel.com/board/posts/5475029/bookmark)
#1 (https://www.mrexcel.com/board/threads/vba-script-to-search-a-text-in-google-maps.1132173/post-5475029)
Dear All,
Hope you are safe at home.
I'm searching for a macro which can make my work easy and i can learn new things in macro.
My Query is very simple.
I have text list in column A text include company name with Location name (ex:"kfc 10003 new york") when i search this in google i can see a map box on right side, which i need to click on it copy the url and paste in column B. Again i wrote a formula in Column C which will separate lat and long value from url.
My request is to get a macro which will search the text and paste the url only which has box location map on the right side of web page and paste in Column B.
I apologize if my way of explaining is not good, I am in learning stage and will sure improve it.
Please find attached screen print of my query.
Thanks in advance.
#1 (https://www.mrexcel.com/board/threads/vba-script-to-search-a-text-in-google-maps.1132173/post-5475029)
Dear All,
Hope you are safe at home.
I'm searching for a macro which can make my work easy and i can learn new things in macro.
My Query is very simple.
I have text list in column A text include company name with Location name (ex:"kfc 10003 new york") when i search this in google i can see a map box on right side, which i need to click on it copy the url and paste in column B. Again i wrote a formula in Column C which will separate lat and long value from url.
My request is to get a macro which will search the text and paste the url only which has box location map on the right side of web page and paste in Column B.
I apologize if my way of explaining is not good, I am in learning stage and will sure improve it.
Please find attached screen print of my query.
Thanks in advance.