Portability of User Defined Functions (UDFs)

		Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
Portability of User Defined Functions (UDFs)

Excel VBA Discuss using VBA for Excel programming.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

May 3rd, 2007, 06:07 PM

fredh

Registered User

Join Date: May 2007

Posts: 2

Thanks: 0

Thanked 0 Times in 0 Posts

Portability of User Defined Functions (UDFs)

I have written some user defined functions in an .xla which work fine on my computer. However, when other users on the network open the file, the UDFs are preceded by their path. Remove the path and the UDF works fine.

Why does Excel do this and how can I make it stop?

Thanks in advance...

- Fred in Texas

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Indexing tables in user defined functions	A17560127	SQL Server 2005	1	July 21st, 2008 03:56 AM
User-defined functions	fredh	Excel VBA	1	May 7th, 2007 10:28 AM
Number format in User Defined Functions	Moose35	Excel VBA	1	February 17th, 2005 05:23 AM
User-Defined Functions - How to recalculate?	kmoran	Excel VBA	1	October 5th, 2004 02:45 AM
user defined functions in vba	re_anu	Access VBA	2	March 3rd, 2004 01:59 PM