View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris S[_2_] Chris S[_2_] is offline
external usenet poster
 
Posts: 2
Default 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?