Peculiar Outlook VBA item, Application_Quit

WeDonNeedNoSteenkgRibbons · #1 07-16-2014, 07:50 AM

Below is my in class module Class1 in Project1 (VbaProject.OTM) (I'm just reading from the Project pane). When I close outlook, I get

Code:

Run-time error '424':
Object required.
(2 buttons, debug and end)

If you click debug, you see the For Each line highlighted in yellow as it's stopped there, and more peculiarly, one second later, the VBA window disappears and you get Dr. Watson asking if you want to report the crash to MS.

Code:

Private Sub Application_Quit()
    Dim olItems As Outlook.Items, olItem As Object, i As Integer
    
    For Each olItem In olItems
        i = i + 1
    Next
End Sub

OL 2007. It happens 100% of the time as I quit Outlook. Advice?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Outlook 'actions' menu item moved to the left?	galgewater	Outlook	0	07-30-2012 07:05 AM
How do I delete an Outlook appointment item with VBA?	Joe Patrick	Outlook	0	07-14-2011 06:56 AM
How to Delete Outlook Item with VBA	Joe Patrick	Outlook	0	07-14-2011 06:49 AM
How do you update existing Outlook calendar item from Word with macro?	Joe Patrick	Word VBA	0	07-09-2011 05:32 AM
Peculiar cell behavior	markg2	Excel	7	05-28-2011 07:46 PM