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
|