ToolBar and button to launch scripts

[JavierJz]

I need to ADD a tool bar or menu in Excel to exec scripts compiled by autoit3, but I don't have any idea.

Tips are welcome ...

[rudi]

Hi.

Well, that's basically an Excel question, but never mind

I need to ADD a tool bar or menu in Excel to exec scripts compiled by autoit3, but I don't have any idea.

Tips are welcome ...

Step1: Write a Macro in Excel calling your AI3 program:

Sub ExternalCall()
Shell "C:\MyTools\MyAutoitScript.exe Param1 Param2 Param3", vbNormalFocus
End Sub

2.) Modify your Excel's tool bar

- Right Mouse Click the toolbar, modify

- 2nd. Tab, "Commands" (?)

- select Macros

- drag-drop one of the icons to your toolbar

- Right Click that new icon in your toolbar, "Assign macro" (?), select the macro you wrote.

Regards, Rudi.

Edited May 7, 2008 by rudi

[JavierJz]

Thanks Rudi, very tks ...

I found how to make the toolbar inside excel in :

http://www.vbaexpress.com/kb/getarticle.php?kb_id=921#instr

and with your tip assing a macro to button and run program AI3.

Regards

[someone]

The answer you have is the easiest way, but I wanted to bring to your attention AnyGUI by quaizywabbit. I am sorry I can't give you any kind of working example, I haven't been able to spend much time with it, hopefully someone who is familiar with it can give you some pointers (ha or maybe I can smarten up and figure it out).

It maybe very well over your head especially since you are just starting out, but at least keep it in the back of your head that that functionality exists.

Make sure you check out Volly's correction to the script to run it under the current ver of autoit. Again, sorry to not give you a better answer. Good luck and welcome to the forum!