VBA started throwing a runtime error recently.

I have a macro developed for my designing and other billing purpose. I run it from CorelDRAW to write the data to external database. I use Access (.mdb) in the backend as the macro is old and have been using it since X4.

Last few days (about a week or so) it started throwing error 429 and I am unable to use the macro. I am using MS DAO 3.6 Object library reference. I doubt if it started since I installed the latest CorelDRAW hotfix. Though not sure if that's true.

Any help is appreciated.

Shelby Moore over 8 years ago

Anand,

Error 429 occurs when COM cannot create the requested Automation object. Here is a Microsoft Support article that should give you some tips and getting things working:

You receive run-time error 429 when you automate Office applications

Hope that helps,

-Shelby
Cancel
Up 0 Down

Reply

Cancel
Anand Dixit over 8 years ago in reply to Shelby Moore

Thanks for the help Shelby and sorry for late reply. We are celebrating Festival of lights - Diwali, here. So on vacation currently. Had a look at the article. Did not really help but will check it again if I could find something.
Cancel
Up 0 Down

Reply

Cancel
Sub GDG_John( ) over 8 years ago

Hi.
As long as your reference is checked in Tools > Reference,
Or a reference is declared in the code, ie late binding...

Comment out your error handling line, example:

'on error goto ....

Place the ' in front of the line.
Run macro. Debugger will stop on problem line.

Sometimes you will have to declare the library the function comes from before the method because of a clash with a method in another library with same named method.

Ie.
VBA.right
or
MsForms.Control
like
MSDAO.mymethod
Cancel
Up 0 Down

Reply

Cancel