analysis toolpak problem

[lars.roennau]

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

 

[OssieMac]

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)

 

[Bob Phillips]

You probably need to manually install the ATP addin when you create the
instance of VBA.

xlApp.AddIns("Analysis Toolpak").Installed = True