Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting Reference to another WorkBook-Problem
I need to set a reference to a WorkBook containing a custom Function which I wish to use in my code in the ActiveWorkbook. I seem to have followed the necessary procedure but still draw the error message "Name conflicts with existing module, project or object library" The procedure is as follows: In the VBE, Tools--References--Browse to locate required file--Select File : Click Open to add a checkBox of VBAProject to the REFERENCES Dialogbox. At this stage, clicking OK should complete the process with the required reference added and evidenced by its addition to the Reference Module but I have the above reported error to reward my efforts. What am I doing wrong? Thanks for any help. David -- davidm ------------------------------------------------------------------------ davidm's Profile: http://www.excelforum.com/member.php...o&userid=20645 View this thread: http://www.excelforum.com/showthread...hreadid=520417 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting Reference to another WorkBook-Problem
Change the project name of the workbook containing the functions
from the default "VBAProject" to something unique like MyFunctions. To do this, in VBA go to the Tools menu, choose VBAProject Properties, and change the name in that dialog. Then, you can set a reference from another workbook to MyFunctions. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "davidm" wrote in message ... I need to set a reference to a WorkBook containing a custom Function which I wish to use in my code in the ActiveWorkbook. I seem to have followed the necessary procedure but still draw the error message "Name conflicts with existing module, project or object library" The procedure is as follows: In the VBE, Tools--References--Browse to locate required file--Select File : Click Open to add a checkBox of VBAProject to the REFERENCES Dialogbox. At this stage, clicking OK should complete the process with the required reference added and evidenced by its addition to the Reference Module but I have the above reported error to reward my efforts. What am I doing wrong? Thanks for any help. David -- davidm ------------------------------------------------------------------------ davidm's Profile: http://www.excelforum.com/member.php...o&userid=20645 View this thread: http://www.excelforum.com/showthread...hreadid=520417 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting Reference to another WorkBook-Problem
Many thanks Chip! It's great to have people like you around. I'm grateful. david. -- davidm ------------------------------------------------------------------------ davidm's Profile: http://www.excelforum.com/member.php...o&userid=20645 View this thread: http://www.excelforum.com/showthread...hreadid=520417 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting a cell reference in one sheet that updates a workbook? | Excel Discussion (Misc queries) | |||
problem sharing an excel workbook when my formulas reference user. | Excel Programming | |||
excel VBA problem - setting workbook as variable & opening/re-opening | Excel Programming | |||
Reference to other workbook problem | Excel Programming | |||
Setting up Reference Library using VBA | Excel Programming |