Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Macro - Extract data from website
Hello, could anyone please help. I have a macro which will pull the URL
address from the excel sheet (more than 100 entries) 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 | |||
How to extract one data from a website | Excel Discussion (Misc queries) | |||
inporting data from website where website address frequently chang | Excel Programming | |||
excel macro to extract data from one worksheet to many spreadsheets | Excel Programming | |||
excel macro to extract data from one worksheet to many spreadsheets | Excel Programming | |||
Macro to Copy data from e-mail and paste it into a field on a website | Excel Programming |