Run Macro

[Meejung]

I have 2 macros set up to automatically export information to an excel
template. When I go to tools and to run macro, neither macro shows up. In
order to run the macros I have to go into VBE and run them from there. Any
clues as to what I am doing wrong? Thanks for any input.

Shelli

 

[Jeff Boyce]

Which version of Access?

What happens when you go to the "macros tab"? Can you see them there?

Is there a chance that what you are calling a "macro" is what Access calls a
"procedure"?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Meejung]

Access 2003. I can't. I think you may be right. It may be a procedure
rather than a macro. Just to be sure, what is the difference and can I turn
a procedure into a macro?

Thanks,
Shelli

 

[Jeff Boyce]

Shelli

Actually, if I recall, you can turn a macro into a procedure somewhat
"automatically", but I don't remember a way to automatically turn a
procedure (which could have non-macro-accessible commands) into a macro.

If you can determine what the procedure does, you may be able to use a macro
to do the same thing, but you'd probably need to create that macro yourself.

Regards

Jeff Boyce
Microsoft Office/Access MVP