Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with ATPVBAEN.XLA
Hi
I'm having problems with the Data Analysis Random Number Generator. If I record putting random nums in some cells I get this bit of VBA: Application.Run "ATPVBAEN.XLA!Random", ActiveSheet.Range("$A$1:$A$10"), 1, 10, 2, , 0, 1 When I re-run it it gives a VB error: Run-time error '1004': The macro " connot be found. Repeating the same thing on an older PC it gives the same bit of code and will re-run. The strange thing is that it HAS re-run on the first PC before - as part of a larger simulation program. Has anyone else experienced this? Or got any ideas as to what may be the problem? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with ATPVBAEN.XLA
Zaman
Do you have the Analysis Toolpak - VBA listed under ToolsAdd-Ins...? If you do, then check it, if you don't, re-run setup and select full install -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Zaman" wrote in message ... Hi I'm having problems with the Data Analysis Random Number Generator. If I record putting random nums in some cells I get this bit of VBA: Application.Run "ATPVBAEN.XLA!Random", ActiveSheet.Range("$A$1:$A$10"), 1, 10, 2, , 0, 1 When I re-run it it gives a VB error: Run-time error '1004': The macro " connot be found. Repeating the same thing on an older PC it gives the same bit of code and will re-run. The strange thing is that it HAS re-run on the first PC before - as part of a larger simulation program. Has anyone else experienced this? Or got any ideas as to what may be the problem? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with ATPVBAEN.XLA
Nick
Yup - Toolpack is installed. And the random numbers still work directly from teh menu. I can also see atpvbaen.xls/xla in the VBAProject window! So it's clearly something minor... Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
atpvbaen link | Excel Programming | |||
Atpvbaen.xls | Excel Worksheet Functions | |||
ATPVBAEN.xls Not Found | Excel Programming | |||
atpvbaen.xls | Excel Programming | |||
Object Orientation / atpvbaen.xla | Excel Programming |