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
|