Calling Fourier plug-in from VBA
 

I want to do an FFT on some data.
I have recorded commands in a macro.

Application.Run "ATPVBAEN.XLA!Fourier",
ActiveSheet.Range("$B$2:$B$4097"), _
ActiveSheet.Range("$J$2:$J$4097"), False, False

But when I run it again I get error 1004.
It says that it can't find ATPVBAEN.XLA.
This worked yesterday.

Someone that has a better way to do it?

Best regards,
/Sören

Calling Fourier plug-in from VBA
 

I have found the problem.
I missed to tab the "Analysis Toolpack - VBA" in Tools - Add-in menu in Excel
and then tab the "atpvbaen.xls" in Tools - Reference - menu in VBA editor.

So now it is working.

BR,
/Sören

"Sören_Marodören" wrote:

I want to do an FFT on some data.
I have recorded commands in a macro.

Application.Run "ATPVBAEN.XLA!Fourier",
ActiveSheet.Range("$B$2:$B$4097"), _
ActiveSheet.Range("$J$2:$J$4097"), False, False

But when I run it again I get error 1004.
It says that it can't find ATPVBAEN.XLA.
This worked yesterday.

Someone that has a better way to do it?

Best regards,
/Sören