View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Business hours calculation

Tools=Addins,
right under Analysis toolpak should be Analysis toolpak - VBA. Just click
the checkbox and it should load.

If it isn't a choice, possibly you need to use add/remove programs in the
control panel to bring up the office setup and install it.

ATPVBAEN.XLA

Will be the file you see in the project explorer in the VBE if it is loaded.
(funcres.xla is the analysis toolpak itself). Before trying to install it,
you might do a search of your drive and see if you have it. If so, use the
browse button in Tools=Addins.
--
Regards,
Tom Ogilvy


"mpfirman" wrote in message
...
I have the analysis toolpack for Excel installed, can't find how to
install the analysis toolpack-VBA?


---
Message posted from http://www.ExcelForum.com/