How do I call Fourier Analysis in Excel2007 in a macro?
That doesn't appear to be the problem.
I've cleared the output range, and clearly inserted the input and output
ranges in the FT routine. I still get the error msg:
Application.Run "ATPVBAEN.XLAM!Fourier", , , False, False
And I've saved the file as macro-enabled (*.xlsm).
In direct application (outside the macro) the FT will overwrite existing
data (a dialog box asks if you wish to do so).
So I still don't know how to run a FT in an Excel97 macro.
- Neal
"Dana DeLouis" wrote:
Application.Run "ATPVBAEN.XLAM!Fourier", , , False, False
It appears your macro is missing the input and output range.
Also note that Fourier can not overwrite the output range if the output
range has data. You have to clear the output range before calling this
function.
= = =
HTH
Dana DeLouis
Neal Carron wrote:
A 2005 thread discussed this in earlier versions of Excel, but the methods
don't work in Excel 2007.
I need to do a Fourier Transform in a macro. The macro inserts
Application.Run "ATPVBAEN.XLAM!Fourier", , , False, False
I keep getting errors there, and the macro stops.
Can anyone help?
|