import data from web page problem

[eHanSolo]

hi there,

i'm trying to get a single figure from a website. I've gone about it by loading the page in Excel which is fine but i want to fully automate this process but can't due to a login prompt.

I have the username and password saved so all that's required is for the 'OK' button to be pressed.

Does anyone know how i can (if it's possible at all!) to use code to 'press ok'??

many thanks!

 

[Andrzejek]

Would SendKeys do the trick?

Have fun.

---- Andy

 

[eHanSolo]

what's 'sendkeys'???

 

[eHanSolo]

oh found it... good ol' help. thanks! i'll look in to it now.

 

[NYFashionToGo]

I was recently experimenting with the send keys as well, It works but it you need to babysit it one small change to the web page and it WILL throw it off...

 

[CautionMP]

eHanSolo,
Here's an alternative to [tt]SendKeys[/tt].
faq707-6400 WebQuery for web sites that require a log in

CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)