Jump to content

Recommended Posts

Posted

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.

Posted

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!

  • 2 months later...
Posted

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

Posted

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

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
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...