Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Analysis Tool
Hello everyone,
I frequently use the Data Analysis Tool, particularly the Histograms, I was wondering if there is a way to write a macro that does this for me, I've been using the macro builder to let the machine built it for me folloiwng all the steps when I do it manually, Tools-Data Analysis-Histogram, selec my Input Range, Bin Range and Output Range; but when I run the macro it comes with this error "ATPVBAEN.XLA could not be found", debug the macro and yes, it stops there, this is the code: Application.Run "ATPVBAEN.XLA!Histogram", ActiveSheet.Range("$A$1:$A$140") _ , ActiveSheet.Range("$F$31"), ActiveSheet.Range("$D$1:$D$21"), False, False _ , False, False _ ActiveWindow.SmallScroll Down:=6 Any help would it be greatly appreciated, Thanks! -- Cesar |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Analysis Tool
Hi,
You need to attach the Analysis ToolPak VBA under Tools, Add-ins. The Analysis ToolPak is not enough. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Cesar" wrote: Hello everyone, I frequently use the Data Analysis Tool, particularly the Histograms, I was wondering if there is a way to write a macro that does this for me, I've been using the macro builder to let the machine built it for me folloiwng all the steps when I do it manually, Tools-Data Analysis-Histogram, selec my Input Range, Bin Range and Output Range; but when I run the macro it comes with this error "ATPVBAEN.XLA could not be found", debug the macro and yes, it stops there, this is the code: Application.Run "ATPVBAEN.XLA!Histogram", ActiveSheet.Range("$A$1:$A$140") _ , ActiveSheet.Range("$F$31"), ActiveSheet.Range("$D$1:$D$21"), False, False _ , False, False _ ActiveWindow.SmallScroll Down:=6 Any help would it be greatly appreciated, Thanks! -- Cesar |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Analysis Tool
Thanks Shane,
I Added the under Add-ins the Analysis ToolPak VBA and created the macro again, but still not working, the macro still stopping at the same instruction, the code still the same, it didn't change after adding the Analysis ToolPak VBA if it had to. Thanks -- Cesar "Shane Devenshire" wrote: Hi, You need to attach the Analysis ToolPak VBA under Tools, Add-ins. The Analysis ToolPak is not enough. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Cesar" wrote: Hello everyone, I frequently use the Data Analysis Tool, particularly the Histograms, I was wondering if there is a way to write a macro that does this for me, I've been using the macro builder to let the machine built it for me folloiwng all the steps when I do it manually, Tools-Data Analysis-Histogram, selec my Input Range, Bin Range and Output Range; but when I run the macro it comes with this error "ATPVBAEN.XLA could not be found", debug the macro and yes, it stops there, this is the code: Application.Run "ATPVBAEN.XLA!Histogram", ActiveSheet.Range("$A$1:$A$140") _ , ActiveSheet.Range("$F$31"), ActiveSheet.Range("$D$1:$D$21"), False, False _ , False, False _ ActiveWindow.SmallScroll Down:=6 Any help would it be greatly appreciated, Thanks! -- Cesar |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Analysis Tool
Shane,
Sorry for the note, but it did work, I just had to close the Excel application and reopened again and it worked perfect! Thanks a lot!! genious! -- Cesar "Shane Devenshire" wrote: Hi, You need to attach the Analysis ToolPak VBA under Tools, Add-ins. The Analysis ToolPak is not enough. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Cesar" wrote: Hello everyone, I frequently use the Data Analysis Tool, particularly the Histograms, I was wondering if there is a way to write a macro that does this for me, I've been using the macro builder to let the machine built it for me folloiwng all the steps when I do it manually, Tools-Data Analysis-Histogram, selec my Input Range, Bin Range and Output Range; but when I run the macro it comes with this error "ATPVBAEN.XLA could not be found", debug the macro and yes, it stops there, this is the code: Application.Run "ATPVBAEN.XLA!Histogram", ActiveSheet.Range("$A$1:$A$140") _ , ActiveSheet.Range("$F$31"), ActiveSheet.Range("$D$1:$D$21"), False, False _ , False, False _ ActiveWindow.SmallScroll Down:=6 Any help would it be greatly appreciated, Thanks! -- Cesar |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Analysis Tool
Hi Cesar,
glad to help and thanks for the feedback. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Cesar" wrote: Shane, Sorry for the note, but it did work, I just had to close the Excel application and reopened again and it worked perfect! Thanks a lot!! genious! -- Cesar "Shane Devenshire" wrote: Hi, You need to attach the Analysis ToolPak VBA under Tools, Add-ins. The Analysis ToolPak is not enough. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Cesar" wrote: Hello everyone, I frequently use the Data Analysis Tool, particularly the Histograms, I was wondering if there is a way to write a macro that does this for me, I've been using the macro builder to let the machine built it for me folloiwng all the steps when I do it manually, Tools-Data Analysis-Histogram, selec my Input Range, Bin Range and Output Range; but when I run the macro it comes with this error "ATPVBAEN.XLA could not be found", debug the macro and yes, it stops there, this is the code: Application.Run "ATPVBAEN.XLA!Histogram", ActiveSheet.Range("$A$1:$A$140") _ , ActiveSheet.Range("$F$31"), ActiveSheet.Range("$D$1:$D$21"), False, False _ , False, False _ ActiveWindow.SmallScroll Down:=6 Any help would it be greatly appreciated, Thanks! -- Cesar |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Analysis Tool
Cesar -
If you'd like a slightly better histogram, see my free Better Histogram add-in, available at www.treeplan.com. Its VBA code is not protected, and you might want to borrow it. - Mike http://www.MikeMiddleton.com "Cesar" wrote in message ... Shane, Sorry for the note, but it did work, I just had to close the Excel application and reopened again and it worked perfect! Thanks a lot!! genious! -- Cesar "Shane Devenshire" wrote: Hi, You need to attach the Analysis ToolPak VBA under Tools, Add-ins. The Analysis ToolPak is not enough. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Cesar" wrote: Hello everyone, I frequently use the Data Analysis Tool, particularly the Histograms, I was wondering if there is a way to write a macro that does this for me, I've been using the macro builder to let the machine built it for me folloiwng all the steps when I do it manually, Tools-Data Analysis-Histogram, selec my Input Range, Bin Range and Output Range; but when I run the macro it comes with this error "ATPVBAEN.XLA could not be found", debug the macro and yes, it stops there, this is the code: Application.Run "ATPVBAEN.XLA!Histogram", ActiveSheet.Range("$A$1:$A$140") _ , ActiveSheet.Range("$F$31"), ActiveSheet.Range("$D$1:$D$21"), False, False _ , False, False _ ActiveWindow.SmallScroll Down:=6 Any help would it be greatly appreciated, Thanks! -- Cesar |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Analysis Tool Pak | Excel Discussion (Misc queries) | |||
How can I add data analysis function in tool? | Excel Worksheet Functions | |||
Where is data analysis tool? | Excel Worksheet Functions | |||
statistics - data analysis tool | Excel Worksheet Functions | |||
How do I add Data Analysis Tool Pak to my Excel 2000? | Excel Discussion (Misc queries) |