LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Calling procedures of a different project

Thanks for your help. I already try this way and work fine.
--
Jorge De la Rosa


"Chip Pearson" wrote:

Another method is to set a reference from the workbook that needs to call
the function to the workbook that contains the function. In the VBA editor,
open the workbook that contains the functions. Go to the Tools menu and
choose "VBA Project Properties". In that dialog, change the name from
"VBAProject"
to something meaningful, like "MyFunctions". Save that workbook. Then open
the workbook that is going call upon the functions, go to the Tools menu,
choose References, and select "MyFunctions" in the list.

Once you have that reference in place, you can call functions in the
"MyFunctions" project as if they were native VBA functions, without any
qualifiers.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Jorge De la Rosa" wrote in
message ...
I have different VBA procedures in different workbooks and I need to call a
procedure from one workbook to another. How can I do this? How is the
right
syntaxis?

I appreciate any help.
--
Jorge De la Rosa




 
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 procedures from within VBA Alex Excel Programming 2 May 11th 06 01:47 PM
Event procedures: who is calling? Momo[_2_] Excel Programming 2 April 22nd 06 08:12 AM
Calling Procedures in other Projects SixSigmaGuy Excel Programming 3 November 5th 04 11:24 PM
Calling procedures in .xla projects Chris Excel Programming 1 July 16th 04 10:28 PM
Calling Procedures jrh Excel Programming 2 March 4th 04 03:34 PM


All times are GMT +1. The time now is 05:22 AM.

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"