I just updraded Office from 2002 to 2007. I had some unique Excel functions
defined in 2002, but these seem to have disappeared in the upgrade. Where do
I find them?

Thanks,

W. Wolfe

They would most likely be in your Personal.xls workbook which would be found in
your XLSTART folder leftover from your Office 2002 installation.

Do a search for either.

OR you placed them into a workbook and created an Add-in from that workbook.


Gord Dibben MS Excel MVP


On Mon, 5 May 2008 07:23:01 -0700, W Wolfe <W
wrote:

I just updraded Office from 2002 to 2007. I had some unique Excel functions
defined in 2002, but these seem to have disappeared in the upgrade. Where do
I find them?

Thanks,

W. Wolfe

I found the functions in the VBA code. For example see the following:

Function GreatCircle(Satlong, ESlatN, ESlongE)
Convert = 180 / Application.Pi
GreatCircle = Convert * Application.Acos(Cos(ESlatN / Convert) *
Cos((ESlongE - Satlong) / Convert))

End Function

But in the spreadsheet where this function is used I get a "#NAME?" error.
Why is Excel not recognizing that name? When I open the workbook I am
enabling macors.

Thanks,

W. Wolfe

"Gord Dibben" wrote:

They would most likely be in your Personal.xls workbook which would be found in
your XLSTART folder leftover from your Office 2002 installation.

Do a search for either.

OR you placed them into a workbook and created an Add-in from that workbook.


Gord Dibben MS Excel MVP


On Mon, 5 May 2008 07:23:01 -0700, W Wolfe <W
wrote:

I just updraded Office from 2002 to 2007. I had some unique Excel functions
defined in 2002, but these seem to have disappeared in the upgrade. Where do
I find them?

Thanks,

W. Wolfe

You found the functions "in the VBA code"..........OK

Where is that code located?

In the workbook you have open or in the Personal.xls?

If the latter, you would preface the function as such...................

=Personal.xls!GreatCircle(arg1,arg2,arg3)

Works fine for me when tested in a separate workbook.


Gord

On Mon, 5 May 2008 16:58:00 -0700, W Wolfe
wrote:

I found the functions in the VBA code. For example see the following:

Function GreatCircle(Satlong, ESlatN, ESlongE)
Convert = 180 / Application.Pi
GreatCircle = Convert * Application.Acos(Cos(ESlatN / Convert) *
Cos((ESlongE - Satlong) / Convert))

End Function

But in the spreadsheet where this function is used I get a "#NAME?" error.
Why is Excel not recognizing that name? When I open the workbook I am
enabling macors.

Thanks,

W. Wolfe

"Gord Dibben" wrote:

They would most likely be in your Personal.xls workbook which would be found in
your XLSTART folder leftover from your Office 2002 installation.

Do a search for either.

OR you placed them into a workbook and created an Add-in from that workbook.


Gord Dibben MS Excel MVP


On Mon, 5 May 2008 07:23:01 -0700, W Wolfe <W
wrote:

I just updraded Office from 2002 to 2007. I had some unique Excel functions
defined in 2002, but these seem to have disappeared in the upgrade. Where do
I find them?

Thanks,

W. Wolfe

The code is in the workbook under a VBA module "ESGrtCir" I guess I will
have to do some more digging on this machine.

Thanks

"Gord Dibben" wrote:

You found the functions "in the VBA code"..........OK

Where is that code located?

In the workbook you have open or in the Personal.xls?

If the latter, you would preface the function as such...................

=Personal.xls!GreatCircle(arg1,arg2,arg3)

Works fine for me when tested in a separate workbook.


Gord

On Mon, 5 May 2008 16:58:00 -0700, W Wolfe
wrote:

I found the functions in the VBA code. For example see the following:

Function GreatCircle(Satlong, ESlatN, ESlongE)
Convert = 180 / Application.Pi
GreatCircle = Convert * Application.Acos(Cos(ESlatN / Convert) *
Cos((ESlongE - Satlong) / Convert))

End Function

But in the spreadsheet where this function is used I get a "#NAME?" error.
Why is Excel not recognizing that name? When I open the workbook I am
enabling macors.

Thanks,

W. Wolfe

"Gord Dibben" wrote:

They would most likely be in your Personal.xls workbook which would be found in
your XLSTART folder leftover from your Office 2002 installation.

Do a search for either.

OR you placed them into a workbook and created an Add-in from that workbook.


Gord Dibben MS Excel MVP


On Mon, 5 May 2008 07:23:01 -0700, W Wolfe <W
wrote:

I just updraded Office from 2002 to 2007. I had some unique Excel functions
defined in 2002, but these seem to have disappeared in the upgrade. Where do
I find them?

Thanks,

W. Wolfe