downloading data for new appointment item from secure website

[Dave the Wave]

I'm retrieving scheduling information from a web site (Active Server
Page) that requires my login name and password. I'm using the
following code to retrieve the web page using Outlook 2007 VBA.

dim strWebPage as string

Sub Start()

On Error GoTo Error_Start
Set IE = CreateObject("InternetExplorer.Application")
IE.Navigate2 [insert URL text here]

end sub

Private Sub IE_DocumentComplete(ByVal pDisp As Object, URL As Variant)
strWebPage = pDisp.Document.Body.innerText
Debug.Print strWebPage
End Sub


The core of the above code was provided by a MSVP from a different
newsgroup, and it works sometimes if I am already logged into the web
site. I was hoping I could modify the URL text to include my login
name and password.

Is this possible and what is the correct syntax?

Thanks in advance.

 

[Brian Tillman]

I'm retrieving scheduling information from a web site (Active Server
Page) that requires my login name and password. I'm using the
following code to retrieve the web page using Outlook 2007 VBA.

microsoft.public.outlook.program_vba is where the programmers hang out.