Add-in functions when starting Excel programmatically

On Fri, 2 Jul 2004 09:16:01 -0700, Vatche
wrote:

I am somewhat confused on a related note. I am trying to make an EDATE call within a function using VBA in excel2000 (part of the analysis toolpak). Unfortunately I receive the error message
"Function or sub not defined" during compilation.
From reading the message boards, I understand this is due to the analysis pack not being loaded up at startup, however I would appreciate if someone could suggest the exact code that I have to include (i.e. an include style statement) to ensure that the EDATE function is visible.

I haven't had time to try it but if you search in Excel 2000 Help for
Analysis Toolpak, one of the articles tells you how to ensure that it
is installed and loaded.

Gale.


Thanks for your help in advance..
Vatche

"Paul Clement" wrote:

On Tue, 13 Apr 2004 14:16:04 -0700, "Steve K." wrote:

¤ Not sure if this question has already been discussed, I couldn’t find an answer in Google newgroups, so your help will be greatly appreciated.
¤
¤ An example: in Excel, under Tools-Add-Ins, select ‘Analysis Toolpack’ option. Now if you go under Insert-Function, you’ll see new functions from that add-in, such as MROUND function under function category ‘All’.
¤
¤ If you close Excel and launch it programmatically, the add-in seems to be loaded (checked) but the functions from it (such as MROUND) are missing. This happens both in 97 and 2000.
¤
¤ To launch Excel I simply created a new VB project with a form and put this code:
¤
¤ Private Sub Form_Load()
¤ Dim oExcel As Excel.Application
¤ Set oExcel = CreateObject("Excel.Application")
¤ oExcel.Workbooks.Add
¤ oExcel.Visible = True
¤ End Sub
¤
¤ Is this an Excel bug or is there something special that needs to be done to load the functions from the add-in?

See if the following helps - the procedure should be the same when using any functionality from the
Analysis TookPak:

HOWTO: Create an Excel Histogram by Using Automation and Analysis ToolPak
http://support.microsoft.com/default...44&Product=vbb

XL2000: Add-Ins Don't Load When Using the CreateObject Command
http://support.microsoft.com/default.aspx?kbid=213489


Paul ~~~
Microsoft MVP (Visual Basic)

On Fri, 02 Jul 2004 18:30:21 +0100, Gale Green
wrote:

I haven't had time to try it but if you search in Excel 2000 Help for
Analysis Toolpak, one of the articles tells you how to ensure that it
is installed and loaded.

Sorry, I didn't mean Excel Help itself - I mean the Help in the Visual
Basic editor in Excel - it's also in the Help you get in the VB IDE
when using Automation.

Gale.