Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Howto: Run Module from Macro or Switchboard 1

Status
Not open for further replies.

brainmetz

Technical User
Feb 12, 2003
34
US
Hello All,

I have two modules that need to be ran from the switchboard and I was going to use a macro to run them, but I can not figure out how to do this...Can some please help. The idea is so that if runme is selected it will excute the code in the runme module.

Thanks for everything.

Shane
 
BTW I found the open module command in the macro, but I dont want the user to see the module code...I just want it to be executed automatically...Is this possible?

Thanks again,

Shane
 
Try looking into the RunCode command. What does BTW mean, I keep seeing it in postings but forget to ask.
 
I looked into the RunCode Command, but it will not let me select my module...

Here is what I see...

Functions
----Built In Function
----MYDB

Under MYDB
I see Module 1 and Module 2
but when I click on them and click OK nothing happens.

Thanks again,

Shane
 
Runcode doesn't actually run a Module, but a Function within a Module. If in your Module 1 you had a Function called Public Function MyFunction1 or Function MyFunction1, in the box displayed at the bottom of the screen after selecting Runcode you would type in MyFunction1()
 
Your a Genius!!!!!!!!!!!

Thanks alot!!!

:)


Shane
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top