VBA Access User-Defined Type not Defined when Running my AutoExec Macro

Asked Jul 18 '18 at 15:37

Active Jul 20 '18 at 09:49

Viewed 106 times

I am trying to test out my code that I have written, and when I go to run my AutoExec macro, I get the error

"User-defined type not Defined"

on the following line of code:

Public Sub WFR_Style(xlBook As Excel.Workbook)

I have the following references set up under my Tools->References:

Am I missing any?

edited Jul 20 '18 at 09:49

Pᴇʜ

asked Jul 18 '18 at 15:37

Jenna Terral

5

Arent you missing an excel object model reference? – Doug Coats Jul 18 '18 at 15:42
How are you specifying the xlbook parameter? – pgSystemTester Jul 18 '18 at 16:03
3

As Doug said, go into Tools>References and Add Excel – Absinthe Jul 18 '18 at 16:07
I am specifying the xlBook as an Object – Jenna Terral Jul 18 '18 at 19:07
If you don't want to set the reference to Excel (why? if you have Outlook and Office already?), you'll need to do `Public Sub WFR_Style(xlBook As Object)` – Andre Jul 19 '18 at 16:05

0 Answers0