Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Northern, NJ, New Jersey, USA
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Run Module from Macro (2003 SP2)

    i have 2 modules built 1- modExport_A_5StarData 2- modExport_D_5StarData

    The Procedures are 1- Export5Star_A_Data 2- Export5Star_D_Data

    I need to run these from a macro that is performing other tasks as well. The 'OpenModule' action opens the VB window but does not actually run the code and the RunCode action opens the Expression Builder but does not allow me to paste the module in the window.

    I know I am close... can anyone push me over?

    Thanks
    There is always a way.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Run Module from Macro (2003 SP2)

    You need to change the procedures (subs) to functions in order to be able to run them from a macro. You can then use the RunCode action with an argument such as
    <code>
    Export5Star_A_Data()</code>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •