Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Joe
 
Posts: n/a
Default How to call a function from another workbook

Dear sir,
how can i call a function or procedure that contained in another workbook ?

thanks
Joe
  #2   Report Post  
Arvi Laanemets
 
Posts: n/a
Default

Hi

When you want to use an UDF or procedure in several workbooks, then save it
into a module of Personal Macro Workbook (Personal.xls, it's created
automatically, when you select Personal Macro Workbook as destination to
save a newly-created macro, and later is loaded automatically whenever you
start Excel).


--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)


"Joe" wrote in message
...
Dear sir,
how can i call a function or procedure that contained in another workbook

?

thanks
Joe



  #3   Report Post  
tjtjjtjt
 
Posts: n/a
Default

One way:
You can also create a Reference between the two workbooks (if they are both
open) from the Tools Menu. To make the reference, both the files should be
open. After that, only the workbook you are using has to be open.

tj

"Joe" wrote:

Dear sir,
how can i call a function or procedure that contained in another workbook ?

thanks
Joe

  #4   Report Post  
Chip Pearson
 
Posts: n/a
Default

After that, only the workbook you are using has to be open.

The workbook which is referenced must be open; Excel will
typically open it automatically for you.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"tjtjjtjt" wrote in message
...
One way:
You can also create a Reference between the two workbooks (if
they are both
open) from the Tools Menu. To make the reference, both the
files should be
open. After that, only the workbook you are using has to be
open.

tj

"Joe" wrote:

Dear sir,
how can i call a function or procedure that contained in
another workbook ?

thanks
Joe



  #5   Report Post  
Chip Pearson
 
Posts: n/a
Default

You can use Application.Run. E.g.,

Applicaiton.Run "Workbook1.xls!TheSub
' or
Result = Application.Run ("Workbook1!TheFunction,1,2,3)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Joe" wrote in message
...
Dear sir,
how can i call a function or procedure that contained in
another workbook ?

thanks
Joe



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
Print all charts in a workbook (multiple worksheets) aewsaws Charts and Charting in Excel 4 May 12th 23 03:45 AM
Update linked cells within a workbook??? Chance224 Links and Linking in Excel 4 January 21st 05 07:33 PM
linking cell value in one workbook to a cell in another workbook Jig Bhakta Links and Linking in Excel 1 January 20th 05 07:12 PM
sotring worksheets in a workbook pineywoods Charts and Charting in Excel 3 December 22nd 04 11:11 PM
copy\paste from one workbook to another Mark Excel Discussion (Misc queries) 0 November 25th 04 11:55 PM


All times are GMT +1. The time now is 02:51 PM.

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

About Us

"It's about Microsoft Excel"