| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I call Fourier Analysis in Excel2007 in a macro?
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I call Fourier Analysis in Excel2007 in a macro?
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I call Fourier Analysis in Excel2007 in a macro?
Sorry, the last sentence should have read Excel2007, not Excel97.
- Neal "Neal Carron" wrote: 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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I call Fourier Analysis in Excel2007 in a macro?
I still get the error msg:
What error message are you getting? If you have data in A1:A4, and C1:C4 is clear, this small demo works in Excel 2007. Sub Demo() Run "ATPVBAEN.XLAM!FOURIER", Range("A1:A4"), Range("C1"), False, False End Sub = = = HTH Dana DeLouis Neal Carron wrote: Sorry, the last sentence should have read Excel2007, not Excel97. - Neal "Neal Carron" wrote: 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? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I call Fourier Analysis in Excel2007 in a macro?
Thanks. I tried your example. Still doesn't work. It says:
Run-time error '1004': Method 'Run' of object '_Application' failed - Neal "Dana DeLouis" wrote: I still get the error msg: What error message are you getting? If you have data in A1:A4, and C1:C4 is clear, this small demo works in Excel 2007. Sub Demo() Run "ATPVBAEN.XLAM!FOURIER", Range("A1:A4"), Range("C1"), False, False End Sub = = = HTH Dana DeLouis Neal Carron wrote: Sorry, the last sentence should have read Excel2007, not Excel97. - Neal "Neal Carron" wrote: 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? |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I call Fourier Analysis in Excel2007 in a macro?
Run-time error '1004':
Method 'Run' of object '_Application' failed Ok. Try this in Excel 2007 Office Button... Excel Options (Near bottom) Add-Ins (On Left) Manage: Excel Add-ins ...click "Go" (Near Bottom) Make Sure Analysis Toolpak and Analysis Toolpak - VBA are both selected. I think it should work now, but I'm guessing... Just a Note: When you write.. Application.Run "ATPVBAEN.XLAM!Fourier", , , False, False One can not tell the size of your input range. Fourier works in 2^k size, so it is hard to tell if the size of your input range was not correct. Manually, Excel will overwrite the data as you mentioned...I was just mentioning the "bug" that has been around a while in that vba generates an error if the output range has data. The output range must be cleared first. Why this has not been fixed yet...I have no idea. :( = = = = HTH :) Dana DeLouis Neal Carron wrote: Thanks. I tried your example. Still doesn't work. It says: Run-time error '1004': Method 'Run' of object '_Application' failed - Neal "Dana DeLouis" wrote: I still get the error msg: What error message are you getting? If you have data in A1:A4, and C1:C4 is clear, this small demo works in Excel 2007. Sub Demo() Run "ATPVBAEN.XLAM!FOURIER", Range("A1:A4"), Range("C1"), False, False End Sub = = = HTH Dana DeLouis Neal Carron wrote: Sorry, the last sentence should have read Excel2007, not Excel97. - Neal "Neal Carron" wrote: 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? |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I call Fourier Analysis in Excel2007 in a macro?
Aaaahhhh. You're a genius.
Analysis Toolpak was activated, but Analysis Toolpak - VBA was not. Works fine now. "Mystery is always annoying, and is usually due to lack of clear analysis" - Bertram Russel. Thanks. - Neal "Dana DeLouis" wrote: Run-time error '1004': Method 'Run' of object '_Application' failed Ok. Try this in Excel 2007 Office Button... Excel Options (Near bottom) Add-Ins (On Left) Manage: Excel Add-ins ...click "Go" (Near Bottom) Make Sure Analysis Toolpak and Analysis Toolpak - VBA are both selected. I think it should work now, but I'm guessing... Just a Note: When you write.. Application.Run "ATPVBAEN.XLAM!Fourier", , , False, False One can not tell the size of your input range. Fourier works in 2^k size, so it is hard to tell if the size of your input range was not correct. Manually, Excel will overwrite the data as you mentioned...I was just mentioning the "bug" that has been around a while in that vba generates an error if the output range has data. The output range must be cleared first. Why this has not been fixed yet...I have no idea. :( = = = = HTH :) Dana DeLouis Neal Carron wrote: Thanks. I tried your example. Still doesn't work. It says: Run-time error '1004': Method 'Run' of object '_Application' failed - Neal "Dana DeLouis" wrote: I still get the error msg: What error message are you getting? If you have data in A1:A4, and C1:C4 is clear, this small demo works in Excel 2007. Sub Demo() Run "ATPVBAEN.XLAM!FOURIER", Range("A1:A4"), Range("C1"), False, False End Sub = = = HTH Dana DeLouis Neal Carron wrote: Sorry, the last sentence should have read Excel2007, not Excel97. - Neal "Neal Carron" wrote: 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? |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I call Fourier Analysis in Excel2007 in a macro?
Had a similar problem and your solution worked beautifully, thank you so much. Keep up the good work!
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Add-in = Fourier Analysis | Excel Worksheet Functions | |||
| How can I call Fourier Analysis from a Visual Basic macro? | Excel Programming | |||
| Fourier Analysis | Excel Worksheet Functions | |||
| Fourier analysis. | Excel Worksheet Functions | |||
| Fourier analysis | Excel Programming | |||
![Neal Carron[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
