Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to debug existing code and the following declaration won't work.
Private x2App As Excel.Application I keep getting an error msg stating "user defined type not defined" Here is the Type statement I have in the declaration section of my class module. Private Type UserDefinedType Application As Object Workbook As Object Worksheet As Object End Type Private Type UserDefinedType2 Connection As Object Command As Object Parameter As Object Recordset As Object End Type Option Explicit Dim Excel(1 To 3) As UserDefinedType Dim ADODB(1 To 19) As UserDefinedType2 Any solutions? -- TWN |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help: Compile error: type mismatch: array or user defined type expected | Excel Programming | |||
"User-defined type not defined" message in Excel | Excel Discussion (Misc queries) | |||
Workspace faux user-defined type not defined | Excel Programming | |||
User-defined data type; Error: Only User-defined types... | Excel Programming | |||
Word.Document - user defined type not defined | Excel Programming |