running a module with no arguments from macro 1

[blom0344]

Can anyone point me to the solution how to RUN a module from a macro. The macro offers me the oppurtunity to open a module, but i want to run it, without opening it. (When i give a run command from within the module it does what i want it to do,, so the VBA is okay .....)
T. Blom
Information analyst
tbl@shimano-eu.com

 

[mp9]

There is a macro action RunCode - this takes one parameter, Function Name. Just enter your function name in this parameter and you're away.

http://www22.brinkster.com/accessory/

 

[blom0344]

Yeah,

I got as far as that, problem is the VBA contains just a subroutine, no function. And the RunCode option in the macro does not allow the calling of a subroutine.........................................................................................!!

Any other ideas?? T. Blom
Information analyst
tbl@shimano-eu.com

 

[mp9]

Any reason why you can't change your

Sub

to a

Function

?

http://www22.brinkster.com/accessory/

 

[blom0344]

Hi mp,

Sometimes the solution is too obvious ,but you hit it right on the head. Changed to function and all is well...
A star for you............. T. Blom
Information analyst
tbl@shimano-eu.com