making a user-defined function accessible to all workbooks

dpolson · Apr 16th, 2002, 06:54 PM

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 · Apr 16th, 2002, 07:25 PM

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 · Apr 16th, 2002, 07:39 PM

Thanks for the help, Ricky!

Yogi Anand · Apr 16th, 2002, 07:48 PM

Quote:

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 · Apr 17th, 2002, 03:58 PM

You can also save the functions in personal.xls

Yogi Anand · Apr 17th, 2002, 04:24 PM

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 · Apr 17th, 2002, 04:39 PM

Quote:

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 · Apr 17th, 2002, 04:47 PM

Quote:

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

Quote:

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 · Apr 17th, 2002, 04:58 PM

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 · Apr 18th, 2002, 10:43 AM

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!

Apr 16th, 2002, 07:25 PM	#2
Ricky Morris Board Regular Join Date: Mar 2002 Posts: 363	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. __________________ It's never too late to learn something new. Ricky

Apr 17th, 2002, 03:58 PM	#5
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	You can also save the functions in personal.xls __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 16th, 2002, 06:54 PM	#1
dpolson New Member Join Date: Apr 2002 Posts: 17	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?

Apr 16th, 2002, 07:39 PM	#3
dpolson New Member Join Date: Apr 2002 Posts: 17	Thanks for the help, Ricky!

Apr 17th, 2002, 04:24 PM	#6
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	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 ]

Apr 17th, 2002, 04:58 PM	#9
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	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

Apr 18th, 2002, 10:43 AM	#10
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	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!