Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
When I open an Excel Application via VBA the Analysis ToolPac functions are
not loaded. (Specially I want to see the function "EDATE" but there are others nice functions.) VBA: Dim appWB As Excel.Application Set appWB = CreateObject("Excel.Application") appWB.Workbooks.Open Filename:="c:\mydocs\myXLWB.xls", ReadOnly:=False appWB.Visible = True Even when I set the addins property to True they are not recognized: 'Install Analysis Tool pack AddIns("Analysis ToolPak").Installed = True Any Suggestions? Thank you, Mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Equivalent of Access "Load" Event? | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Excel 2003 to 2007 Analysis ToolPack Errors ="#N/A" | Excel Worksheet Functions | |||
have tried to load analysis toolpac but als nothing happens | Charts and Charting in Excel | |||
unable to load "Excel" analysis toolpak tried the tools and brows | Excel Discussion (Misc queries) |