making a user-defined function accessible to all workbooks

[dpolson]

I've got a couple of user-defined functions that I coded in via one workbook (wkb A), but would like these functions to be accessible to any workbook (wkb B...Z). How is this done so that when I start a new blank wkb I can use these user-defined functions there as well?

 

[Ricky Morris]

Save the file with the function with an xla extension. This will tell Excel that it's an add-in workbook. Then Select Tools > Add-Ins from the menu and browse to the xla file you saved. The function will now be available to all workbooks in Excel.

 

[dpolson]

Thanks for the help, Ricky!

 

[Yogi Anand]

On 2002-04-16 19:25, Ricky Morris wrote:
Save the file with the function with an xla extension. This will tell Excel that it's an add-in workbook. Then Select Tools > Add-Ins from the menu and browse to the xla file you saved. The function will now be available to all workbooks in Excel.

Thanks from me too Ricky!

Yogi Anand

 

[Al Chara]

You can also save the functions in personal.xls

 

[Yogi Anand]

Hi Al:
I have some UDFs saved in Personal Workbook but they work only in Worksheets of the Personal Workbook and not in Worksheets of other Workbooks (even though the UDF is declared as Public). Any ideas what else needs to be done?
This message was edited by Yogi Anand on 2002-04-17 16:25

 

[Jay Petrulis]

On 2002-04-17 16:24, Yogi Anand wrote:
Hi Al:
I have some UDFs saved in Personal Workbook but they work only in Worksheets of the Personal Workbook and not in Worksheets of other Workbooks (even though the UDF is declared as Public). Any ideas what else needs to be done?
This message was edited by Yogi Anand on 2002-04-17 16:25

You have to fully qualify the call, i.e. tell Excell where to find the function.

=[Your Workbook.xls]MyFunct(Arg1, Arg2)

should work.

Bye,
Jay

 

[Yogi Anand]

On 2002-04-17 16:39, Jay Petrulis wrote:

On 2002-04-17 16:24, Yogi Anand wrote:
Hi Al:
I have some UDFs saved in Personal Workbook but they work only in Worksheets of the Personal Workbook and not in Worksheets of other Workbooks (even though the UDF is declared as Public). Any ideas what else needs to be done?
This message was edited by Yogi Anand on 2002-04-17 16:25

You have to fully qualify the call, i.e. tell Excell where to find the function.

=[Your Workbook.xls]MyFunct(Arg1, Arg2)

should work.

Bye,
Jay

Thanks Master Jay! That might be it ... I will try that.

 

[Jay Petrulis]

Hi Yogi,

If the brackets don't work, try referencing the workbook with an exclamation point.

I know it's something like this, but have never needed it, so I have no experience with the syntax.

Bye,
Jay

 

[Yogi Anand]

Hi Jay:
It worked with the ! preceded by the name of the workbook.xls -- I did not need to enclose the name of the workbook in []s.

THANKS!