View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Thomas Auburn Thomas Auburn is offline
external usenet poster
 
Posts: 1
Default Calling Procedures from another excel sheet by passing objects

Hi,
I like to keep all my general purpose procedures/functions in a
seperate excel sheets as series of modules to maintain them at a
single location. How can I call them from another working sheet
without importing the applicable module. The Application.run does not
allow me to pass objects per HELP.

Help screen says "Objects passed as arguments to the macro are
converted to values (by applying the Value property to the object).
This means that you cannot pass objects to macros by using the Run
method"

Thanks