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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sharing code between projects

Status
Not open for further replies.

mpopnoe

Programmer
Feb 28, 2002
47
0
0
US
I referenced workbook "B" from workbook "A" so I could use the code (in standard modules) from "B" in "A". However, I don't know how to call these subs/functions that reside in "B". I also tried placing some code in "B" in a class module and tried to call that in code but have had no success.

What I want to do is create an object based on "B" that allows me to directly call the subs/functions in that workbook.

When you reference a project (Tool|References) how do you call it's subs/functions? do i have to use Application.Run?

thanks,
mike
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top