Medic873 Posted March 17, 2010 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.
Fulano Posted March 17, 2010 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!
Medic873 Posted June 4, 2010 Author 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
DW1 Posted June 4, 2010 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
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