Clicking a web page button with an Excel macro

[rde99]

I can get to the following web page:http://finance.yahoo.com/p?k=pf_1.
(Sign on:mistertester2, Password:M8R-hlylld) from an Excel macro, but how do I code the macro to click on the "download spreadsheet" button?

 

[dave3009]

What to do is use Excel connection wizard to connect to the website (rather than have a macro access IE). You enter your username and password then you can check an arrow to download the table. Now all you need to do is run the macro recorder while refreshing the table and you can apply the code to your button

 

[rde99]

I using XP Pro with Office 2000. I've never used the connection wizard. Is it even available in Excel 2000?
After clicking on the "download spreadsheet" I want the macro to do a copy of B2:B34).

Bob

 

[rde99]

I'm using Office 2000. From an Excel workbook I've tried Data/Get External Data/New Web Query (entering the web page as http://finance.yahoo.com/q/hp?s=GOOG). It always returns the error "Unable to open http://finance.yahoo.com/q/hp?s=GOOG. Cannot locate the Internet server or the proxy server" even though I can get to the web page by putting that URL in a new (Firefox) browser tab. Is there something wrong with Excel 2000?

Is there another way I can get the data via Excel macro?

Thank you for your suggestion Dave3009.

Anybody?

Bob

 

[bestox]

try this:

ie.Navigate "javascript:buttonSubmit('OK')"
u = "[URL]http://www.url[/URL]ofthepageiwanttogo.com"
    ie.Navigate u