Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
Outlook
bcm
calendaring
contacts
fax
general
installation
interop
outlook
printing
program_addins
program_forms
program_vba
teamfolders
thirdpartyutil
  
 
date: Mon, 23 Jun 2008 17:38:36 -0400,    group: microsoft.public.outlook.interop        back       


downloading data for new appointment item from secure website   
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.
date: Mon, 23 Jun 2008 17:38:36 -0400   author:   Dave the Wave

Re: downloading data for new appointment item from secure website   
Dave the Wave  wrote:

> 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.
-- 
Brian Tillman [MVP-Outlook]
date: Tue, 24 Jun 2008 09:43:17 -0400   author:   Brian Tillman

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us