Running Code from a Macro

[jalge2]

I have a command button that imports text into a table.

The code is called Import_New_File_Click (). I'm trying to get that code to run from a macro but I'm not sure how. I copied that code into a module and saved it as Module 1. I can't get the runcode in the Macro to run this module.

I know it's a stupid problem but thanks for the help anyway.

Jason Alge
Jason.M.Alge@lowes.com

'There are three kinds of people: Those who can count and those who can't'

 

[DoubleD]

Instead of using a macro, why not call your code from more code. It will be more efficient and more functional.

I am what I am based on the decisions I have made.

DoubleD

 

[sfreeman]

Create a new macro [or add to existing macro] a RunCode command. Inser the name of the function in the parameter field.

But, macros suck, and except for an ocassional Autoexec macro, should be avoided.

Sam_F
"90% of the problem is asking the right question.