Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error in Excel 97 when running Excel 2000 macro | Excel Programming | |||
Error in Excel 97 when running Excel 2000 macro | Excel Programming | |||
Error in Excel 97 when running Excel 2000 macro | Excel Programming | |||
Error in Excel 97 when running Excel 2000 macro | Excel Programming | |||
Launch Macro in Access via Macro running in Excel??? | Excel Programming |