<div>
if you're not familiar with the immediate window (Ctrl+G) then you should try to get to know it. Or you can run this code which uses a msgbox instead. 

<pre><code class="code-10 nolinks" id="code-120419">Sub listControlsSummary()
Dim ctrl As CommandBarControl, strOutput As String
 
 
For Each ctrl In Application.CommandBars(1).Controls
 
strOutput = strOutput &amp; &quot;Index &quot; &amp; ctrl.Index &amp; &quot;:&quot; &amp; ctrl.Caption &amp; vbCrLf
 
Next
 
MsgBox &quot;Your control indexes are &quot; &amp; vbCrLf &amp; strOutput
 
End Sub
 
 
Sub listControlsDetail()
Dim ctrl As CommandBarControl, strOutput As String
 
For Each ctrl In Application.CommandBars(1).Controls(10).Controls
 
strOutput = strOutput &amp; &quot;Index &quot; &amp; ctrl.Index &amp; &quot;:&quot; &amp; ctrl.Caption
 
Next
MsgBox &quot;Your control indexes are &quot; &amp; vbCrLf &amp; strOutput
End Sub
 
Sub RunMenuItem()
 
Application.CommandBars(1).Controls(10).Controls(22).Execute
 
End Sub
</code></pre>
</div>

<div>
Thanks nutsch, 
 
This worked excellent and I now understand how to be able to access any of the functions on the command bar. 
 
Thanks, 
 
taduh
</div>

<div>
Glad to help. 
 
Thomas
</div>

<div>
<div class="content wysiwyg-content">
I am a super-newbie to AutoIT, but I saw it as a potential way to get around inconsistent behavior I have seen from the VBA SendKeys command. I have created an AutoIT executable which i call from within Excel VBA. It contains only one line of code: 
 
Send(&quot;!XE&quot;,0) 
 
This is to supposed to send the key Alt-X, followed by the keystroke E to run a menu item on an Essbase add-in that appears on my Excel toolbar, but the net result is that it types an E in the current cell on the active spreadsheet. 
 
Any suggestions would be greatly appreciated. 
 
Thanks, 
 
taduh
</div>
</div>

I am a super-newbie to AutoIT, but I saw it as a potential way to get around inconsistent behavior I have seen from the VBA SendKeys command. I have created an AutoIT executable which i call from within Excel VBA. It contains only one line of code: 

Send("!XE",0)

This is to supposed to send the key Alt-X, followed by the keystroke E to run a menu item on an Essbase add-in that appears on my Excel toolbar, but the net result is that it types an E in the current cell on the active spreadsheet.

Any suggestions would be greatly appreciated.

Thanks,

taduh

Trying to get a very simple AUTOIT executable to work in place of a VBA Sendkeys command

A scripting language is a programming language that supports scripts, programs written for a special run-time environment that automate the execution of tasks that could alternatively be executed one-by-one by a human operator. Scripting languages are often interpreted (rather than compiled). Primitives are usually the elementary tasks or API calls, and the language allows them to be combined into more complex programs. Environments that can be automated through scripting include software applications, web pages within a web browser, the shells of operating systems (OS), embedded systems, as well as numerous games. A scripting language can be viewed as a domain-specific language for a particular environment; in the case of scripting an application, this is also known as an extension language.

Scripting Languages

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.