Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
calling a C++ program from Excel 2000 and passing a result from C++ back to an excel spreadsheet ellis kurland Excel Discussion (Misc queries) 3 August 15th 05 04:10 PM
Calling a Sub passing Textbox name Ducttape19 Excel Programming 2 April 7th 04 01:35 PM
Calling Procedures jrh Excel Programming 2 March 4th 04 03:34 PM
Calling objects Stewart[_3_] Excel Programming 1 November 26th 03 10:10 AM
Passing ARGUMENTS between event procedures of a USERFORM jason Excel Programming 8 November 10th 03 07:36 PM


All times are GMT +1. The time now is 09:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"