saving as an add-in?
 

I've written some functions at work and saved the workbook as an add-in.

Another workbook that used this add-in worked fine at work but not when
I brought it home (presumably as the add-in was not on my home machine)

So I copied the text of the functions, put them in a new workbook at
home and saved that as an add-in at home.

At first the workbook that used the add-in functions would not re-calc
at home so I used the add-in manager to install my add-in but then it
required me to re-enter all of the user defined function calls in the
cells as they displayed a path to the add-in on my work machine. I guess
that I'll also have to repeat this in reverse when I take it back to work.

How do I get the functions in this add-in to work smoothly between
locations?

Howard

saving as an add-in?
 

Howard

Functions and Macros from add-ins don't require that the workbook path and name
be inserted.

=MyFunction() is all that is required if the add-in is loaded through
ToolsAdd-ins

If calling a function from another workbook you need the

=path\myworkbook.xls!MyFunction()

That is the beauty of using an add-in.

Get rid of all the references and you should be good to go at home and at work.

When I was working I did this all the time.


Gord Dibben MS Excel MVP


On Thu, 31 Jan 2008 21:05:28 +0000, Howard wrote:

I've written some functions at work and saved the workbook as an add-in.

Another workbook that used this add-in worked fine at work but not when
I brought it home (presumably as the add-in was not on my home machine)

So I copied the text of the functions, put them in a new workbook at
home and saved that as an add-in at home.

At first the workbook that used the add-in functions would not re-calc
at home so I used the add-in manager to install my add-in but then it
required me to re-enter all of the user defined function calls in the
cells as they displayed a path to the add-in on my work machine. I guess
that I'll also have to repeat this in reverse when I take it back to work.

How do I get the functions in this add-in to work smoothly between
locations?

Howard