LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
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
Setting a cell reference in one sheet that updates a workbook? Danhalawi Excel Discussion (Misc queries) 1 November 7th 06 04:08 PM
problem sharing an excel workbook when my formulas reference user. Waiward Engineer Excel Programming 1 March 1st 05 05:41 PM
excel VBA problem - setting workbook as variable & opening/re-opening safe Excel Programming 1 August 20th 04 12:22 AM
Reference to other workbook problem Terry Carpenter Excel Programming 0 April 3rd 04 01:45 AM
Setting up Reference Library using VBA Alan Excel Programming 1 November 5th 03 03:18 AM


All times are GMT +1. The time now is 01:13 AM.

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"