View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John P[_2_] John P[_2_] is offline
external usenet poster
 
Posts: 29
Default Missing:ATPVBAEN.XLA

Hi. I have been trying to use the Dateadd function but a dialog box pops up
saying can't find project or library and missing ATPVBAEN.XLA

Following instructions from some of the forums, I clicked the Microsoft
Office button and went to the add-ins and loaded in the Analysis Toolpak and
Analysis Toolpak-VBA (atpvbaen.xlam). But the problem still persists.

In my VBE, the Tools/References dialog still shows missing ATPVBAEN.XLA. In
searching for this file, I found these 4 files in Office12/library/analysis:
Analy32 (blue square), atpvbaen (red square), funcres (red square) and procdb
(red square). Can anyone advise me what's wrong? Thank you for your advice.