View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default analysis toolpak problem

Couple of things to look at but not sure if it will help.

There are 2 Analysis ToolPak addins. Analysis ToolPak and Analysis Toolpak -
VBA. Have you got both selected?

Another thing in Power Point in the VBA window. Menu Item Tools - References.
Scroll down until you find Microsoft Excel 11.0 Object Library. Check the
box and OK. (Ensure you check the box; not just highlight the line)

--
Regards,

OssieMac


" wrote:

hallo newsgroup,
hope that this is the right place to post my problem.
from powerpoint i start a excel workbook, that contains a project
plan. to calculate start and end date of project steps i use the
analysis toolpak function "networkdays". usually that works fine, but
if i start excel from powerpoint with vba (i want to import status
information in a powerpoint presentation), the analysis toolpak
function does not work. (the analysis toolpak is visible in the tools/
add-in dialog). after disabling the dialog and enabling it one more
time manually, the function works fine.
any idea?

thanks in advance
lars

_____-
i work with office 2003 professional, international edition / windows
xp