By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,486 Members | 2,169 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,486 IT Pros & Developers. It's quick & easy.

How to get Macro contents with VBA

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
In the DB window and a macro highlighted > Tools > Macros > Convert to VB

HTH
David B

Dennis Macdonald <ne********@bandwood.com> wrote in message
news:d9**************************@posting.google.c om...
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.


Nov 12 '05 #2

P: n/a
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" <Da***@marleycotenospam.fsnet.co.uk> wrote in message
news:c5**********@news6.svr.pol.co.uk...
In the DB window and a macro highlighted > Tools > Macros > Convert to VB

HTH
David B

Dennis Macdonald <ne********@bandwood.com> wrote in message
news:d9**************************@posting.google.c om...
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.

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.