Medic873 Posted March 17, 2010 Share Posted March 17, 2010 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. Link to comment Share on other sites More sharing options...
Fulano Posted March 17, 2010 Share Posted March 17, 2010 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 More sharing options...
Medic873 Posted June 4, 2010 Author Share Posted June 4, 2010 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 More sharing options...
DW1 Posted June 4, 2010 Share Posted June 4, 2010 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 AutoIt3 Online Help Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now