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

112 Views Asked by At

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:

  • Microsoft Access 16.0 Object Library
  • OLE Automation
  • Microsoft ActiveX Data Objects 6.1 Library
  • Microsoft Outlook 16.0 Object Library
  • Microsoft Office 16.0 Access database engine object library
  • Visual Basic for Applications

Am I missing any?

0

There are 0 best solutions below