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
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