Open https web page in VBA

Hi,

I try to create a database base on my company's information on the web.
What I try to achieve is I have a table which contains the addresses and I want the VBA goes to each address, open it and copy a section of the page and import it into another table. The web site is https.

Regards,
Andrew
ishadowmeAsked:
Who is Participating?
 
harfangCommented:
Hello,

You will need a browser to open the pages. For example MS's WebBrowser ActivX control. You can instruct it to navigate to the desired page, examine the text or html content, etc.

You can look at {http:/Q_21597349.html}, using the text only.

Cheers!
(°v°)
0
 
ishadowmeAuthor Commented:
thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.