Thread: Enable Excel reference in Outlook to create Object

Hi,

I've been trying to write a subroutine that will call an Excel macro. The problem that I'm having is that the following line of code:

Dim eApp As Excel.Application

returns an Object Required Error. I searched for an answer and found that most solved this problem by Clicking on Tools Reference and Adding a Reference to Excel.

I have looked through the list of references many times and can not find any mention of Excel. Everything else seems to be on the list, Access, OneNote, Power Point, but not Excel.

How do I get Outlook to reference Excel?