Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workspace faux user-defined type not defined
I have a user whose spreadsheet quit 'working'.
A button on the first worksheet executes a macro that uses several declarations, Dim ws As Workspace Dim db As Database Dim rs As Recordset The Workspace, Database, and Recordset are all 'undefined.' When I scan in the VBA Object Browser for 'Workspace' all I get is Excel and VBA DAO doesn't show up. We have another workbook that IS working. This one shows DAO in the Object Browser. Questions: How do I get the DAO module BACK into the workbook?? HOW did this user eliminate it in the first place?? HOW do I keep her from doing it again? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workspace faux user-defined type not defined
in the VBE, check references in the tools menu. select where appropriate. If Microsoft DAO version x is listed as ISMISSING then try to start excel with /regserver on the commandline. -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Chris S wrote : I have a user whose spreadsheet quit 'working'. A button on the first worksheet executes a macro that uses several declarations, Dim ws As Workspace Dim db As Database Dim rs As Recordset The Workspace, Database, and Recordset are all 'undefined.' When I scan in the VBA Object Browser for 'Workspace' all I get is Excel and VBA DAO doesn't show up. We have another workbook that IS working. This one shows DAO in the Object Browser. Questions: How do I get the DAO module BACK into the workbook?? HOW did this user eliminate it in the first place?? HOW do I keep her from doing it again? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workspace faux user-defined type not defined
Thanks a BUNCH! The References tab on the one that was working had
Microsoft DAO in it. I just added that ref to the bad one and it's all happy now. "keepITcool" wrote: in the VBE, check references in the tools menu. select where appropriate. If Microsoft DAO version x is listed as ISMISSING then try to start excel with /regserver on the commandline. -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Chris S wrote : I have a user whose spreadsheet quit 'working'. A button on the first worksheet executes a macro that uses several declarations, Dim ws As Workspace Dim db As Database Dim rs As Recordset The Workspace, Database, and Recordset are all 'undefined.' When I scan in the VBA Object Browser for 'Workspace' all I get is Excel and VBA DAO doesn't show up. We have another workbook that IS working. This one shows DAO in the Object Browser. Questions: How do I get the DAO module BACK into the workbook?? HOW did this user eliminate it in the first place?? HOW do I keep her from doing it again? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workspace faux user-defined type not defined
in the vbe go to tools=References and see if you have a reference marked as
MISSING. If so, is it a reference to DAO? In any event, you need to create a reference to DAO. It is possibly in a different location on this machine. -- Regards, Tom Ogilvy "Chris S" wrote in message ... I have a user whose spreadsheet quit 'working'. A button on the first worksheet executes a macro that uses several declarations, Dim ws As Workspace Dim db As Database Dim rs As Recordset The Workspace, Database, and Recordset are all 'undefined.' When I scan in the VBA Object Browser for 'Workspace' all I get is Excel and VBA DAO doesn't show up. We have another workbook that IS working. This one shows DAO in the Object Browser. Questions: How do I get the DAO module BACK into the workbook?? HOW did this user eliminate it in the first place?? HOW do I keep her from doing it again? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Message "user defined type not defined" | Excel Discussion (Misc queries) | |||
"User-defined type not defined" message in Excel | Excel Discussion (Misc queries) | |||
User-defined data type; Error: Only User-defined types... | Excel Programming | |||
User Defined type not defined | Excel Programming | |||
Word.Document - user defined type not defined | Excel Programming |