it is defined in the xl4 macro help file:


http://support.microsoft.com/?id=143466
xlmacr8.hlp
http://support.microsoft.com/?id=128185
macrofun.exe

--
Regards,
Tom Ogilvy

"bandy2000" wrote in message
...
HI,
Thanks for the info. I did what you told to do. Then I used the Macro
Recorder and it came out to use the FFT like this:

Application.Run "ATPVBAEN.XLA!Fourier", , "ResultFFT", False , False

Where do I find further information on the options for the Fourier
Function.
There is nothing in the Help Infromation in VBA or at least I can't find
it.
For Example where do I enter the Range etc....

"Chip Pearson" wrote:

If you are talking about the functions in the Analysis Tool Pack,
you need to set a reference to the ATP VBA add-in. In Excel, go
to the Tools menu, choose Add-Ins, and select "Analysis Tool Pak
VBA" from the list and put a check next to it. Then, go to the
VBA Editor, choose the Tools menu, then References. In that
dialog, put a check next to "ATPVBAEN.xla". Once you do this,
you can use the ATP functions as if they were built in VBA
functions.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"bandy2000" wrote in
message
...
hi,

How can I use the FFT Add In in a Macro?
How can I use the Engineering Functions in a Macro?
Maybe someone can provide short example codings
Thanks