histogram and macros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If you record a macro while creating a histogram (data analysis add-in), it
will not run, with error 1004 "ATPVBAEN.MLA cannot be found". Same happens
with correlation. I have searched my computer: this file does not exist.
Am I looking at an undocumented Microsoft bug? PS This is in Excel 2002 and
2000, I don't know about 2003.
 
ATPVBAEN.XLA which is the Analysis Toolpak for VBA, should be found in the
Office\Library\Analysis folder.

If not there, perhaps go to Control Panel>Add/remove and Select Office 2003 and
"Change".

Go through the steos and see if you can get ATPVBAEN.XLA installed.

You will most likely need the CD.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Analysis Tool 5
Histogram in reverse order 1
Histograms...and buttons 1
Histogram/Frecuency for Multiple Response Questions 1
Where to get Excel 2003 add-ins (Data Analysis/Histograms)? 2
Coding Histogram add in tool 1
histograms with normal distributions 4
Skip Override Prompt in Macro 3

Back
Top