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?

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?

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?

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?