Jump to content

Excell Addin


Recommended Posts

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!

Link to comment
Share on other sites

  • 2 months later...

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

Link to comment
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
Link to comment
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
 Share

  • Recently Browsing   0 members

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