View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave F.[_4_] Dave F.[_4_] is offline
external usenet poster
 
Posts: 6
Default This is not strictly excel, but I am running it from an excel macro

Hi

I anyone knows a better NG to get an answer, please let me know.

Anyway... I'm trying to load a password protected web page:

http://extranet.4projects.com/

This is as far as I've got:

Sub Projects_4()
Dim oIE As New SHDocVw.InternetExplorer

Set oIE = New SHDocVw.InternetExplorer
oIE.Navigate "http://extranet.4projects.com/ "
Do Until Not oIE.Busy
DoEvents
Loop
oIE.Document.all("Login").Click
Do Until Not oIE.Busy
DoEvents
Loop
oIE.Visible = True
oIE.Document.all("txtpassword").Value = "password" ' This gives an "object
not set" etc. error
End Sub

The Login button displays a popup which I've no idea how to 'grab hold of'
to pass the password/login info.
The oIE variable still contains the original web page object.

The Source should give me some clues, but I haven't a clue.

Any help would be greatly appreciated.

Cheers

Dave F.