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 |
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 |