Macro error 1

[wysiwygGER01]

Hello,

I'm using Accpac 5.5 on an Windows Server 2008.
I've written a macro which runs fine if you open the Macro under Edit and run through it there.
When I try to link to it from within Accpac or try running it under Macro > Run from menu I get the following error message:
Macro did not run for unknown reason (Error code = 2147747134).

Would anyone know what the problem is?

 

[Jay Converse]

Make sure the last statement is "Exit Sub", not "End

 

[wysiwygGER01]

Thanks tuba. i've changed that now but still the same.
Wol dit have anything to do with having all my code in a form instead of a module?

I'm using a form for that macro.

 

[Jay Converse]

You have to start with a module that calls the form.

 

[wysiwygGER01]

thanks tuba,
done that now and it works!