Autoit on excel 2013

[mark1983]

Thanks! I will be looking out for your message.

-M

[water]

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.

[mark1983]

Thanks so much for your help. It worked.

[water]