Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a "Data Analysis" add-in function in a macro
I've been trying to create a macro that runs the "Rank and Percentile function included in the "Data Analysis" add-in. However, every time run the macro I get an error message saying: Run-time error '1004': 'ATPVBAEN.XLA' could not be found. Check the spelling of the fil name, and verify that the file location is correct. If you are trying to open the file from your list of most recently use files on the File menu, make sure that the file has not been renamed moved, or deleted. - The macro is stored in the same workbook that has the data I'm tryin to run the analysis on. - My version of Excel is whatever comes with Office XP Pro, I thin Excel 2002. Any help is appreciated ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a "Data Analysis" add-in function in a macro
go into Tools=Addins and select Analysis Tookpak - VBA
this should load ATPVBAEN.XLA Then you have to use Application.run to run the code, or create a reference from you workbook to ATPVBAEN.xla and then you can call it like a native function (not worksheet function, like a vba function). -- Regards, Tom Ogilvy hawkeyes2002 wrote in message ... I've been trying to create a macro that runs the "Rank and Percentile" function included in the "Data Analysis" add-in. However, every time I run the macro I get an error message saying: Run-time error '1004': 'ATPVBAEN.XLA' could not be found. Check the spelling of the file name, and verify that the file location is correct. If you are trying to open the file from your list of most recently used files on the File menu, make sure that the file has not been renamed, moved, or deleted. - The macro is stored in the same workbook that has the data I'm trying to run the analysis on. - My version of Excel is whatever comes with Office XP Pro, I think Excel 2002. Any help is appreciated. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
Where did my "Analysis Group" under Data tab go?!?!? | Excel Discussion (Misc queries) | |||
adding "Data Analysis" to my Excel | Excel Worksheet Functions | |||
Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) | |||
Excel 95 had a "data analysis" option, how can I access on XP? | Excel Discussion (Misc queries) |