Home VBA web scrape REFERENCE
Reply: 0

VBA web scrape REFERENCE

user548
1#
user548 Published in April 24, 2018, 8:25 am

After navigating to the website, I have a list of names in a spreadsheet I need to populate into the search field, how do I reference the spreadsheet in the macro?

from the Navigate command, I have the Url, it asks for first name, last name which i have populated in the spreadsheet.

How do I reference the cells from the spread sheet?:

first_name= **A1** &last_name= **B1** &state=TX&country_code=US

something similar to this, with a loop statement? A1 B1 as example

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.830661 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO