Calling Fourier plug-in from VBA


G

Guest

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
 
Ad

Advertisements

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top