Hello Newgroup,
I have attempted to create an add-in for Excel 2003 with the code from
Harln Grove's
interesting function called "pull". This function will pull data from
a closed workbook, and can be used on worksheets/workbooks with
various excel functions like match, index, etc.

I have pasted the code into a workbook as a module, and local to the
workbook, all works well, I can refer to the function: pull("path to
workbook and range"), and it works fine.

So I then tried to make it an add-in so I can use it in all my
workbooks.
No dice. I created a new empty workbook, added the code as a module
called "PullFunction" and tested the code on the single sheet in this
new book. it works.

I then saved the file as an add-in, PullFunction.xla. I then opened
up one of my other workbooks to see if the add-in shows up and is
usable.

I can add the add-in, using Tool/add-ins etc. But when I type the
function name (pull), and the path/workbook/sheet/range variable
pull("path\'[workbook]Sheet1'!A1:C12")

I get a name error on the worksheet, which tells me it is not really
getting to the addin
What am I missing?