#1
|
|||
|
|||
User-defined Type not Defined VBA Issue
Hi Folks
I have some sample code from the web to open an mpp file but I am getting the following error message on the first few lines of code as shown below: Sub Sample() Dim appProj As MSProject.Application Dim aProg As MSProject.Project Dim wb As Workbook Dim ws As Worksheet Error message: User-defined type not defined I have ticked the Reference to Microsoft Office 14.0 Object Library and I am using Office/Project 2010. I have also referenced the Microsoft DAO 3.6 Object Library. Any advice would be appreciated to resolve this issue. Kind regards Tony Post script: Just found the issue, I was missing two References for MS Project. |
#2
|
|||
|
|||
Wow, asked and answered!
|
#3
|
|||
|
|||
Hi Julie
That will teach me to look properly before posting :0). Tony |
#4
|
|||
|
|||
Better you found it than someone else
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
FileSystemObject Compile Error: User-Defined Type Not Defined | gsrikanth | Excel Programming | 2 | 03-28-2022 06:32 AM |
Excel 2003 User Defined Function | Allan_H | Excel | 1 | 03-08-2013 09:36 AM |
Range.Information(wdStartOfRangeRowNumber): Application-defined or Object-defined err | tinfanide | Excel Programming | 2 | 06-09-2012 10:19 AM |
Application-defined or Object-defined error | Manit | Excel Programming | 4 | 12-08-2011 07:35 PM |
User Defined Default Settings in Insert | J_oe | Word | 1 | 02-17-2011 10:55 AM |