Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to extract data from webpage
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to extract data from webpage
Try going to the web site first and leaving it up.
-- Don Guillett Microsoft MVP Excel SalesAid Software "Icy" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Extract and Sort Macro Help | Excel Programming | |||
MACRO TO EXTRACT DATA | Excel Programming | |||
Macro to extract the data in a certain cell | Excel Programming | |||
Macro to extract data | Excel Discussion (Misc queries) | |||
Open Sheet, Run Macro, Extract data | Excel Programming |