Functions / Macros - Array question

[dvent]

Hi everyone!

I have created a large function, shown below (cut down):

Please Login or Register  to view this content.

I then have a macro that runs as:

Please Login or Register  to view this content.

How can I make it so that legacy1, and therefore legacy1path is only defined once rather than every time a different CreateExceptions line runs in my macro.

It probably is simple, but I have become confused.

Thanks!
dvent

[dominicb]

Good afternoon dvent

You will need to take the file picker routine out of the function, and perhaps put it into the Exceptions macro. This will then run when the macro is run, not when the function is called.

You will also need to share the legacy1path variable between the two macros. To do this take the dim statement out of the function, and place it right at the top of the module, so that it comes before either of the procedures, but not in either of them. They should both be able to access this variable without a problem.

HTH

DominicB

[dvent]

Good afternoon dvent

You will need to take the file picker routine out of the function, and perhaps put it into the Exceptions macro. This will then run when the macro is run, not when the function is called.

You will also need to share the legacy1path variable between the two macros. To do this take the dim statement out of the function, and place it right at the top of the module, so that it comes before either of the procedures, but not in either of them. They should both be able to access this variable without a problem.

HTH

DominicB

Thanks DominicB. Works as described.