View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
lee hite lee hite is offline
external usenet poster
 
Posts: 4
Default distributing add-ins

On Tue, 14 Oct 2003 13:01:12 -0400, "jaf" wrote:

Place the add-in in what your computer returns for
Application.UserLibraryPath when you build it.
In your code always use Application.UserLibraryPath in ref. to your add-in.


John -- i'm not using the add-in functions in code -- they are being
used in cell values. for example, i have a function that calculates a
specialized average called CAVG -- so a given cell might have the
value CAVG(A1:A100,B1:B100,D1). i don't think i can use
Application.UserLibraryPath in the cell reference???

lee