VBA AUTOMATION OF INTERNET EXPLORER

[Nashtrump1]

Hi all,

Im building a small function in excel which opens an internet explorer page, logs in to a members area and then in theory will download into excel using (data range queries) information that non members cannot see.

However the problem im having is that this particulare website wont allow me to log in using internet explorer and then access non member pages via excel vba.

Any idea how i transfer a session object over or something so excel vba knows im logged into the website?

Kind regards

Nash

 

[hermanlaksko]

I use this code in access perhaps you can use it in excel?
Dim User, HTTP
If Not IsNull(Me!InetUser) Then User = "?ref=" & Me!InetUser
If Left(Me!InetAdr, 4) <> "Http" Then HTTP = "

http://"

& Me!InetAdr Else HTTP = Me!InetAdr
If Not IsNull(User) Then fHandleFile HTTP & User & ";", WIN_NORMAL Else fHandleFile HTTP & User, WIN_NORMAL


Herman
Say no to macros

 

[CautionMP]

Nashtrump1,
Are you pulling the data into Excel using a WebQuery and hung up on how to get past the login?
faq707-6400 : WebQuery for web sites that require a log in

Hope this helps,
CMP

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