Macro to extract data from webpage

[Icy]

Hello, could anyone please help. I have a macro which will pull the URL
address from the excel sheet and open the website then extract the data from
it. (using for loop) I am running into a problem, where a pop up Security
Alert window will appear when excel try to open some URL.
"Information you exchange with this site cannot be viewed or changed by
other. However, thre is a problem with the site's security certificate. Do
you want to proceed?"
I have to manual click on Yes to bypass this so the loop will contiune. I
tried to set my web page security setting to low, still doesn't work. Anyway
can have a macro to detect a web security pop up and answer "Yes"
automatically? Or is there a better way to do this?
Thanks!

 

[Don Guillett]

Try going to the web site first and leaving it up.

 

[Icy]

Thank you for your reply, but I have hundreds URL that macro has go through
and extract data out of each website. could you please clarify by going to
the website first and leaving it up. thanks!