How to get Macro contents with VBA

[Dennis Macdonald]

Can anyone tell me how to extract the contents of a Macro with VBA. I
already have the name etc from the Documents properties, but I need
the actual macro commands.

Thanks in advance,
Dennis.

[David B]

Re: How to get Macro contents with VBA

In the DB window and a macro highlighted > Tools > Macros > Convert to VB

HTH
David B

Dennis Macdonald <newsgroups@ban dwood.com> wrote in message
news:d98b592e.0 404112118.1c7cf 93a@posting.goo gle.com...[color=blue]
> Can anyone tell me how to extract the contents of a Macro with VBA. I
> already have the name etc from the Documents properties, but I need
> the actual macro commands.
>
> Thanks in advance,
> Dennis.[/color]

[Allen Browne]

Re: How to get Macro contents with VBA

That's not a bad approach.

Another alternative is the undocumented SaveAsText (and the matching
LoadFromText).

--
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.

"David B" <David@marleyco tenospam.fsnet. co.uk> wrote in message
news:c5dakg$cu5 $1@news6.svr.po l.co.uk...[color=blue]
> In the DB window and a macro highlighted > Tools > Macros > Convert to VB
>
> HTH
> David B
>
> Dennis Macdonald <newsgroups@ban dwood.com> wrote in message
> news:d98b592e.0 404112118.1c7cf 93a@posting.goo gle.com...[color=green]
> > Can anyone tell me how to extract the contents of a Macro with VBA. I
> > already have the name etc from the Documents properties, but I need
> > the actual macro commands.
> >
> > Thanks in advance,
> > Dennis.[/color][/color]