Excel 2002 & Vba & active-x creation problem 429

K

Kari

Hi

I have an excel worksheet and done some things with vba
and now when changed to WXP and Excel 2002 it stopped
working. Below is the line of code where it stops and
gives message "runtime error 429 - active-x can't create
object".

Only thing is that it tries to open a dummy database.

Set dbs = Workspaces(0).OpenDatabase(strDir & "\app.mdb")

Would be very nice to have some advises what the h..l is
wrong with it. Was there enough info about that -
hopefully.

regards
kari
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top