Upgrade from 2002 to 2007

[W Wolfe]

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

 

[Gord Dibben]

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

 

[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]

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

 

[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