Darren Dick
D.Dick at uws.edu.au
Mon Jun 13 21:28:16 CDT 2005
Hello all
(Cross Posted to Sue and Dmitri's list)
The code below used to work - now it doesn't
Our enterprise has moved to Exchange - does that matter?
The error is
ERR.Number = -2147024769
ERR.Description = Method 'Connection' of object '_CurrentProject' failed
Any suggestions?
Code snip below
Dim rs As Object
Dim con As Object
Dim objOutlook As Outlook.Application
Dim objAppt As Outlook.AppointmentItem
Dim objRecurPattern As Outlook.RecurrencePattern
Set objOutlook = CreateObject("Outlook.Application")
Set objAppt = objOutlook.CreateItem(olAppointmentItem)
Set rs = CreateObject("ADODB.Recordset")
Set con = Application.CurrentProject.Connection
'<=============Error here