AutoExec MACRO

[PhilOfWalton]

I use very few Macros, so I have little experience of them

Below is an AutoExec Macro

This works perfectly well providing the is a second Macro called "AutoExecOriginal"

I can't use VBA Code as I am renaming a Client's Original AutoExec (IF IT EXITS) to AutoExecOriginal. Then I want to run My AutoExec first, then the Client's Original AutoExec.

What I want to do is if the AutoExecOriginal Macro can't be found, just exit the AutoExec macro. No error messages, no saving of the error in the Macro Object.

Can this be done?

Phil

[NeoPa]

In the [Condition] column of the macro call a VBA function procedure that returns True if the macro exists and False otherwise.

This will ensure the line is only ever executed if it actually exists.

[PhilOfWalton]

So simple... I leave you to decide whether that refers to the solution or me.

Thanks

Phil

[NeoPa]

Like most experience Phil, it ain't simple till you have it.

I've been fortunate enough to have had to work on databases that included a lot of macro work originally.