Excel 2002 & Vba & active-x creation problem 429

  • Thread starter Thread starter Kari
  • Start date Start date
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
 
Back
Top