Hi all,

I am keep trying to generate an MS Outlook Task from Excel Vba.
I thought I can first open Outlook, and then trying to generate task o
note.
First of all, could anybody help me with the first step, opening M
Outlook?

Iam trying this code unsuccessfuly: (I use Outlook 03 with Xp prof)


Private Sub OpeningOutlook()
Dim OutLk As Application
Dim B As String

B = "C:\Program Files\Microsoft Office\OFFICE11\OUTLOOK.EXE"
Set Out = GetObject(B)
OutLk.Application.Open

OutLk.Application.Visible = True
'Here generating task or note
OutLk.Parent.Windows(1).Visible = True
OutLk.Application.Quit
End Sub


Thank you all!
Aldo

--
Message posted from http://www.ExcelForum.com