Enable Excel reference in Outlook to create Object

[Extradimensional]

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:

Please Login or Register  to view this content.

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?

[Extradimensional]

I figured it out!

I went into my Excel VBA Editor and noticed that it did have an Excel Object in the references. I copied the path from that object (C:\Program Files (x86)\Microsoft Office\Office12\EXCEL.EXE), and added it to the reference in outlook manually using the browse button. And now it works!