Jenna Terral
Reputation: 77
VBA Access User-Defined Type not Defined when Running my AutoExec Macro
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?
Upvotes: 0
Views: 109
Answers (0)
Related Questions
- Compile error: User-defined type not defined when updating an older macro for Access library
- Macro Error 2001 Autoexec Access Macro
- Trying to Run Access Macro from
- Access VBA: AutoExec macro can't find function?
- Executing Microsoft Access Autoexec macro when opening Microsoft Excel file
- Compile Error: User-defined type not defined Access/Excel Reference
- VBA User-Defined type not defined
- Access 2010 compile error User-defined type not defined
- AutoExec Module not Initiating
- cannot find name when running AutoExec macro