View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Sören_Marodören Sören_Marodören is offline
external usenet poster
 
Posts: 18
Default 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