JKP Application Development Services.

Microsoft Office Application Development

Fix Links to UDFs

Up • Defined Names • Corrupt Files • Create Addins • Startup Problems • Chart an Equation • Show Picture • Round2Digits • Control Events • Custom Find • FormulaWrapper • Disable Events • Workbook Open Bug • WebQuery • Register UDFs • Undo With Excel VBA • Select a range (VBA) • Transpose Table • Docking VBE Windows • Excel 2007 Tables • Excel 2007 Tables (VBA) • Update An Addin • Addin Installation • Object Lister • Excel 2007 FileFormat • Catch Paste • Listbox AutoSize • Fix Links to UDFs

• Methods to Fix #Name! Errors • Detecting Workbook Opening • Processing The Newly Opened Workbook • Handle Workbooks Opened From Explorer •

Search

Zoeken

Go to	Ga Naar
Home Up Methods to Fix #Name! Errors Detecting Workbook Opening Processing The Newly Opened Workbook Handle Workbooks Opened From Explorer

Donate	Donaties
Did you find something helpful on my site? Consider a donation! Heeft u iets gevonden waar u wat aan had? Overweeg dan een donatie!

Fixing Links To UDF's in Addins

Introduction

Excel has a host of built-in functions to help you do your computations. But sometimes you need to write your own functions using VBA. These functions are called "User Defined Functions" (UDF). UDF's typically are placed in addins. As long as the addin is installed, the UDF's work as expected. You get into trouble when the location of the addin changes, for example because you have distributed the Addin to your co-workers and they have installed it to their local user addin folder (which is different for each user!).

As soon as a file which uses the UDF is opened on a system that uses a different addin path, all cells that use your UDF show #NAME! errors. Also, the complete path to the original location of the add-in is shown in each formula:

='C:\data\FixLink2UDF.xla'!UDFDemo(A1,A2)

This article describes a couple of ways to avoid/resolve this situation.

Read on...

Content

Methods to Fix #Name! Errors
Detecting Workbook Opening
Processing The Newly Opened Workbook
Handle Workbooks Opened From Explorer

Subscribe in a reader