mark1983 Posted November 8, 2013 Author Share Posted November 8, 2013 Thanks! I will be looking out for your message. -M Link to comment Share on other sites More sharing options...
Solution water Posted November 8, 2013 Solution Share Posted November 8, 2013 I got it to work this way: #include <Excel Rewrite.au3> Global $oExcel = _Excel_Open() ; Connect to Excel or open a new instance Global $oWorkbook = _Excel_BookOpen($oExcel, "C:\temp\Report Consolidator v8.xlam") ; Open the Excel Macro file WinActivate("Microsoft Excel") ; Wait for Excel to come up $iRC = Send("!yri") ; Add-Ins - Report Consolidator - Item Analysis $hWindow = WinWait("Folder Path") ; Wait for the window to appear $iRC = ControlSend($hWindow, "", 4900, "C:\temp") ; Enter the path $iRC = ControlClick($hWindow, "", 1) ; Click OK $hWindow = WinWait("Process Complete") ; Wait for the Process Complete window $iRC = ControlClick($hWindow, "", 2) ; Click OK Looks like you can't automate an Add-In using COM. My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
mark1983 Posted November 11, 2013 Author Share Posted November 11, 2013 Thanks so much for your help. It worked. Link to comment Share on other sites More sharing options...
water Posted November 11, 2013 Share Posted November 11, 2013 My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki 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