analysis toolpak problem
 

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

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

analysis toolpak problem
 

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

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


--
__________________________________
HTH

Bob

wrote in message
...
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