WEBVTT

00:02.180 --> 00:04.460
OK guys I almost forgot to cover this.

00:04.710 --> 00:05.210
Never.

00:05.250 --> 00:10.230
What happens if you want to call one of your custom functions from another way a book.

00:10.230 --> 00:16.350
Well we already know here that our pi will work perfectly well when we type it in the workbook in which

00:16.350 --> 00:20.770
we've created this perfect control in an add a new file.

00:20.890 --> 00:27.910
And here I typed pi as particularly if like it's spelled pi and sell exactly the same thing.

00:27.990 --> 00:34.590
It is not going to know what we're looking at because it is looking in book two for a custom function

00:34.710 --> 00:37.080
called pi and it doesn't exist.

00:37.110 --> 00:43.500
So what we need to do is specify the path to the file that does contain the custom function.

00:43.500 --> 00:51.450
Now this file must be open now where the quickest way probably to to say we anticipate everything is

00:51.450 --> 00:54.420
going to say equals and what we say.

00:54.420 --> 01:01.110
So open rackets open quotes and we can say file name close close close brackets and enter a mega.

01:01.110 --> 01:05.330
Let's say you get the file Mame and path it's going to copy that.

01:05.520 --> 01:08.430
Copy and Paste Special over the top.

01:08.430 --> 01:10.190
And this is the bit I am after.

01:10.200 --> 01:12.070
The user defined function.

01:12.100 --> 01:16.590
The DOT Excel s and it it'll be in Excel s s s.

01:16.590 --> 01:21.840
Excel has X when you download it because I can't upload files with macros in them.

01:21.840 --> 01:25.980
So what we have to do have an apostrophe have the name of the file have another POS.

01:25.980 --> 01:33.090
We have an exclamation point that tells Excel book to to go look at use the defined functions and the

01:33.090 --> 01:35.820
extension and then retrieve the function.

01:35.820 --> 01:41.020
So when I hit enter boom they go that say use it from a different workbook.

01:41.130 --> 01:44.940
Okay that concludes this section and I'll see you in the next one.

01:44.940 --> 01:46.230
Thanks very much.
