VBA Error - Class Not Registered

[Dave Punky]

Hi All,

I'm hoping somebody on here can help me with this as Google has not been very useful at all in trying to solve this.

I'm currently running Windows 7 (Ultimate, 32-bit) along with MS Office 2007 Enterprise and I'm trying to use the ListView functions or the DTPicker. I've enabled MS DAO objects in references but whenever I try to use the custom function to make changes I get this error:

I've only just reimaged my machine along with reinstalling Office, although I was having this problem before. It happens with any additional functions I try to add in, but mainly when I try to access custom functions.

Has anybody else experienced this error or more notably does anybody know how to fix this?

 

[Dave Punky]

@ rorya

Yep, completely formatted the HDD and installed fresh, so there's no Windows.old file or anything which could be causing this problem.

 

[RoryA]

Hmm, curious. Did you run the command prompt as an administrator when you registered the dll and ocx files?

 

[Dave Punky]

@ rorya

Yeah I did, I'm the only user on this machine and I default everything as an admin.

If I try and register Msstkprp.dll, because it's not finding it it won't register at all but everything else will register without issue.

 

[RoryA]

Oh - I thought you said you had downloaded it?

 

[Dave Punky]

I have although the ones I have downloaded just dont activate - although I just managed to activate it and it seems to be working - restarting the machine after putting the file in the directory and then activating it seems to make all the difference.