Sign in to follow this  
Followers 0
Medic873

Excell Addin

4 posts in this topic

Here is the code im working with

#include <Excel.au3>
$oExcel = _ExcelBookNew()

Now auto it loads excel but once auto it loads excel it won't seem to load my excel addin's.

How can I make it load my excel addins.

Share this post


Link to post
Share on other sites



I'm sorry, you'll have to be more specific.


#fgpkerw4kcmnq2mns1ax7ilndopen (Q, $0); while ($l = <Q>){if ($l =~ m/^#.*/){$l =~ tr/a-z1-9#/Huh, Junketeer's Alternate Pro Ace /; print $l;}}close (Q);[code] tag ninja!

Share this post


Link to post
Share on other sites

Bump lol its been awhile since Ive work with this issue and need to finish this project lol...

Okay im opening a excel workbook obviously. And I have purchased a excel add in to pull data from the web for me.. The addin works great but when ever auto it loads the excel workbook it seems to load it fast and not load properly and never load the workbook.

Excell still runs fine but my addin isn't there.

Thank You

Share this post


Link to post
Share on other sites

Here's the basic idea:

$sAddIn = "C:\Path\add_in.xla" ; Change this to the filepath of your AddIn

$oExcel = ObjCreate("Excel.Application")
$oExcel.WorkBooks.Add
$oAddIn = $oExcel.AddIns.Add($sAddIn)
$oAddIn.Installed = True
$oExcel.Quit

I am not sure but I think that if you already have the addin installed, you can skip the Addins.Add step and simply call

$oExcel.AddIns("XLAname.xla").Installed = True

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0