Konverting macro to vba code...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jan T - 17 Sep 2007 10:51 GMT

Is there an easy way to convert Access 2003 macros to vba-code?

Thank you in advance.

Regards
Jan T.

Reply to this Message

Allen Browne - 17 Sep 2007 11:10 GMT

Try:
Tools | Macros | Convert to code

It's not the same as writing decent code, but it is essentially equivalent
to executing the macro.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Is there an easy way to convert Access 2003 macros to vba-code?
>
> Thank you in advance.
>
> Regards
> Jan T.

Reply to this Message

Jan T - 17 Sep 2007 12:53 GMT

> Try:
> Tools | Macros | Convert to code
[quoted text clipped - 14 lines]
>
> - Vis sitert tekst -

Right. The database I am thinking of, do have a lot of macros
already.
But, is there a way to push a button or a menu item to change
or convert the macro's to vba-code?

Like Tools/ DatabaseTools/ compress ... or something similar....

I think I remember having that done, but I am not sure and can't
figure out what
I did.
Any id?a?

Regards
Jan

Reply to this Message

UpRider - 17 Sep 2007 22:58 GMT

Jan, communicatons problem.
Allen's instructions will convert macros to VBA code. What he was saying is
that the conversion will not necessarily result in well written code. The
converter is clumsy and literal, sometimes humorous, but it works.

UpRider

On 17 Sep, 12:10, "Allen Browne" <AllenBro...@SeeSig.Invalid> wrote:

> Try:
> Tools | Macros | Convert to code
[quoted text clipped - 18 lines]
>
> - Vis sitert tekst -

Reply to this Message