Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Interop / June 2008

Tip: Looking for answers? Try searching our database.

downloading data for new appointment item from secure website

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dave the Wave - 23 Jun 2008 22:38 GMT
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 - 24 Jun 2008 14:43 GMT
> 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.
Signature

Brian Tillman [MVP-Outlook]

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.