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

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