Forum

VBA Selenium Data E...
 
Notifications
Clear all

VBA Selenium Data Extraction

2 Posts
2 Users
0 Reactions
100 Views
(@selvabhelp)
Posts: 1
New Member
Topic starter
 

Hello,

I am a beginner in Selenium.

I am trying to extract data but its coming blank.
Can you check what I am missing?

Here is what I am doing:

[url] http://property.franklincountyauditor.com/_web/search/commonsearch.aspx?mode=parid [/url]
Enter parcel ID "010-016698-00" or any other ID

Search

Click "View Google Map"

Google Maps will open in another Tab

abc = bot.FindElementByClass("section-hero-header-title").Text
MsgBox abc

Can anyone tell the correct code?
Also how do I wait till web page is loaded?

Alternatively
Is there a way to extract directly from VBA without selenium from Google maps URL?

Thanks.

 
Posted : 11/05/2021 6:26 am
(@catalinb)
Posts: 1937
Member Admin
 

Hi,

You have here an example for using selenium: https://www.myonlinetraininghub.com/web-scraping-filling-forms

You should be able to get geolocation data from Google Maps API, of Bing Maps API, however they are not free, you might need a subscription to use their api:

https://docs.microsoft.com/en-us/bingmaps/rest-services/locations/find-a-location-by-query

 
Posted : 16/05/2021 11:47 pm
Share: