AutoExec in VBA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BOONER - 25 Sep 2006 22:09 GMT

How do I write code in a module that will act like an AutoExec macro?
Basically, I need the same results that "sub Auto_open()" would give in
Excel.

Reply to this Message

Douglas J. Steele - 25 Sep 2006 22:41 GMT

Create an AutoExec macro that calls your code. (Remember that macros can
only call Functions, not Subs)

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> How do I write code in a module that will act like an AutoExec macro?
> Basically, I need the same results that "sub Auto_open()" would give in
> Excel.

Reply to this Message

BOONER - 26 Sep 2006 15:03 GMT

Excelent

> Create an AutoExec macro that calls your code. (Remember that macros can
> only call Functions, not Subs)
>
> > How do I write code in a module that will act like an AutoExec macro?
> > Basically, I need the same results that "sub Auto_open()" would give in
> > Excel.

Reply to this Message

Klatuu - 25 Sep 2006 22:45 GMT

Write your code as a function.
Use the RunCode action in the Autoexec macro and specify the name of the
function.
The RunCode action will only run functions. No return value is required.

> How do I write code in a module that will act like an AutoExec macro?
> Basically, I need the same results that "sub Auto_open()" would give in
> Excel.

Reply to this Message

BOONER - 26 Sep 2006 15:03 GMT

Thanks

> Write your code as a function.
> Use the RunCode action in the Autoexec macro and specify the name of the
[quoted text clipped - 4 lines]
> > Basically, I need the same results that "sub Auto_open()" would give in
> > Excel.

Reply to this Message