Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recording a macro for a Data Analysis add-in
I am recording and running the macro on the same pc. Nice idea though - you
never know! Thanks for your thoughts on this. I guess I shall just have to work around this problem. "Alok" wrote: Hi Is it possible that you are recording the Macro on one computer (the one that has the Add-In) and running it on another computer that does not have the add-in? That can explain the 1004 Error message. I am still trying to figure out why the macro does not save the ranges! Alok "Andybro" wrote: No change - the recorded macro does not show the ranges I select. I am using an input range of $W$5:$W$75, a bin of $R$5:$R$16 and an output range of $E$59. If I run the macro it shows a run time error 1004, explaining that ATPVBAEN.XLA could not be found. "Alok" wrote: Hi, When I recorded a macro for histogram I got the following.. Application.Run "ATPVBAEN.XLA!Histogram", ActiveSheet.Range("$E$8:$E$35"), _ ActiveSheet.Range("$P$8"), ActiveSheet.Range("$G$8:$G$12"), False, False, _ False, False I am not sure why your macro is not recording the ranges. You may like to try again and provide all the inputs. Alok "Andybro" wrote: I am trying to automate the creation of several histograms and so need to use the "Analysis Toolpak" add-in. I have manually produced these histograms but as I will need to refresh them weekly I wish to be able to regenerate the histograms automatically. I tried recoding a macro which followed my method for creating the chart. However. The VBA module does not record my input, bin or output selection. The only line recorded is Application.Run "ATPVBAEN.XLA!Histogram", , , , False, False, False,False If I then run the macro this command is not recognised anyway. How can I automate the creation of a histogram as available in the Analysis Toolpak of Excel 2003? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recording a macro for a Data Analysis add-in
On Jan 6, 3:23 am, Andybro wrote:
I am recording and running themacroon the same pc. Nice idea though - you never know! Thanks for your thoughts on this. I guess I shall just have to work around this problem. "Alok" wrote: Hi Is it possible that you are recording theMacroon one computer (the one that has theAdd-In) and running it on another computer that does not have theadd-in? That can explain the 1004 Error message. I am still trying to figure out why themacrodoes not save the ranges! Alok "Andybro" wrote: No change - the recordedmacrodoes not show the ranges I select. I am using an input range of $W$5:$W$75, a bin of $R$5:$R$16 and an output range of $E$59. If I run themacroit shows a run time error 1004, explaining that ATPVBAEN.XLA could not be found. "Alok" wrote: Hi, When I recorded amacrofor histogram I got the following.. Application.Run "ATPVBAEN.XLA!Histogram", ActiveSheet.Range("$E$8:$E$35"), _ ActiveSheet.Range("$P$8"), ActiveSheet.Range("$G$8:$G$12"), False, False, _ False, False I am not sure why yourmacrois not recording the ranges. You may like to try again and provide all the inputs. Alok "Andybro" wrote: I am trying to automate the creation of several histograms and so need touse the "Analysis Toolpak"add-in. I have manually produced these histograms but as I will need to refresh them weekly I wish to be able to regenerate the histograms automatically. I tried recoding amacrowhich followed my method for creating the chart. However. The VBA module does notrecordmy input, bin or output selection. The only line recorded is Application.Run "ATPVBAEN.XLA!Histogram", , , , False, False, False,False If I then run themacrothis command is not recognised anyway. How can I automate the creation of a histogram as available in the Analysis Toolpak of Excel2003?- Hide quoted text - - Show quoted text - Not to change the topic of this thread, but I have been having difficulty recording the use of ANY add-in in ANY macro. I have searched the usenet groups for months on this with no luck. I wonder if you're facing the same larger issue I am of not being able to record actions used in add-ins. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Analysis Toolpak-Confidence Level and data analysis questions | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
Why " data analysis plus " override " data analysis " once instal. | Excel Worksheet Functions | |||
Analysis ToolPak installed but no Data Analysis option | Excel Discussion (Misc queries) |