Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to open a web page through macro?
Does anyone have any suggestions on how to open a web page through macro?
I have a list of web page to be opened everyday as shown below www.appledaily.atnext.com www.cnn.com www.yahoo.com.hk .... I would like to run a macro to open each web page individually. Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to open a web page through macro?
Her isd a small piece of code from one of my macros
Sub GetDealers() 'Dim PageNumber As Object Set IE = CreateObject("InternetExplorer.Application") IE.Visible = True URL = "http://www.nissanusa.com/apps/dealerlocator" Request = "?zipCode=07508&tool=Home.Locator" 'get web page IE.Navigate2 URL & Request Do While IE.readyState < 4 DoEvents Loop 'get search button Set but = IE.document.getElementById("mainSearchButton") 'put distance in listbox on webpage Set radius = IE.document.getElementById("radius") radius.Value = "100" 'search again a larger distance 'Select Search button and activate but.Select but.Click end sub "Eric" wrote: Does anyone have any suggestions on how to open a web page through macro? I have a list of web page to be opened everyday as shown below www.appledaily.atnext.com www.cnn.com www.yahoo.com.hk ... I would like to run a macro to open each web page individually. Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
contact page to be the first page I see when I open outlook | New Users to Excel | |||
contact page to be the first page I see when I open outlook | New Users to Excel | |||
when i open a excel doc , it open muiltple page not related? | Excel Discussion (Misc queries) | |||
Macro that copy page to page just some filled cells | Excel Discussion (Misc queries) | |||
How do I get my personal macro worksheet to open whenever I open . | Excel Discussion (Misc queries) |