• Subject: downloading data for new appointment item from secure website
  • Author: Dave the Wave
  • Date: 23 Jun 2008
  • References:
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.
23 Jun 2008downloading data for new appointment item from secure website.Dave the Wave
24 Jun 2008\ Re: downloading data for new appointment item from secure website.Brian Tillman
All times are in (US) Eastern Daylight Time (GMT -4:00)