Office Macro's no longer working after migration to office2000/win

[Hen]

We have a set of templates that consist of dot files, macro's and a DLL that
contains a number of shared functions. This set has been developed in VBA on
office 97 under windows 98. We now are trying to use the same set of
templates in office 2000 under windows XP SP2. When we run the templates
under a user who has administrator rights or power user rights to the
workstation all seems to be fine. However when a user that has only user
rights tries to run the templates we get the following error:

Automation error ClassFacatory cannot supply requested
class.-2147221231(80040111)

When debugging the error seems to occur at the following line:
Public Property Get code()
Dim constant As Object
Set constant = CreateObject("sjablonen.constante")
code = constant.pass
End Property

Any ideas ?

 

[Benjammin]

I have seen this same error a few times recently. We sell a product that
creates Excel & Word documents. Have hundreds & hundreds of users, and the
same code has been working without problem for years, but recently with Word
2003 I've seen this error.

Tried Detect & Repair in Word, but it does not seem to solve the problem.

The only way I have solved the problem is to uninstall and then re-install
Word/Office.

This can't be the solution though, there has to be something else?

 

[Hen]

We have found the problem. The DLL was not being registered properly, because
the user had only "user rights"at the workstation. We now Use novell's
zenworks to register the DLL as a system user at login, and deregister the
DLL as a system user at logout. This fixed the problem.

Kind regards,

Hen