Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Analysis ToolPak Regression Analysis Help Requested | Excel Worksheet Functions | |||
Analysis ToolPak - exactly the same problem | Excel Discussion (Misc queries) | |||
Analysis Toolpak-Confidence Level and data analysis questions | Excel Worksheet Functions | |||
Analysis Toolpak | Setting up and Configuration of Excel | |||
Analysis ToolPak installed but no Data Analysis option | Excel Discussion (Misc queries) |