Found out how to add reference to AutoItX3.dll, now how can i add the #include in the excel procedure

[danmcg]

so would like to move my autoit script inside the VBE but having an issue with constants. how can i add the #include found in my autoitscript and add that to my excel procedure

Sub LoadAutoIt()

On Error Resume Next

'early binding
Dim autoit As AutoItX3
Set autoit = New AutoItX3

'how can i set the includes so that my program finds the constants?

Call autoit.Run("C:\Program Files (x86)\Office RibbonX Editor\OfficeRibbonXEditor.exe")
Call autoit.WinWait("Office RibbonX Editor")
Call autoit.WinSetState("Office RibbonX Editor", "")
'Sleep (10000)
Call autoit.Send("^o")
Call autoit.Send("C:\Users\USERNAME\Documents\Excel\RibbonTester.xlsm")

End Sub

and here is where it messes up...

Call autoit.WinSetState("Office RibbonX Editor", "", @SW_MAXIMIZE) 

and here is my au3 script (that is working perfectly)

#include <AutoItConstants.au3>
#include <MsgBoxConstants.au3>

run("C:\Program Files (x86)\Office RibbonX Editor\OfficeRibbonXEditor.exe")
WinSetState("Office RibbonX Editor", "", @SW_MAXIMIZE)
sleep(10000)
send("^o")
send("C:\Users\purchasing\Documents\Excel\RibbonTester.xlsm")
sleep(5000)
send("{ENTER}")
send("^a")
send("^v")
sleep(5000)
MouseClick($MOUSE_CLICK_LEFT, 360, 60, 2)

if WinExists("XML is Valid") then
    ;MsgBox($MB_APPLMODAL,"XML is Valid","Your Ribbon Code is Valid",5)
    send("{ENTER}")
    send("^s")
    send("^w")
    winclose("Office RibbonX Editor")
    run("C:\Program Files (x86)\Microsoft Office\root\Office16\excel.exe C:\Users\purchasing\Documents\Excel\RibbonTester.xlsm")
Else
    MsgBox($MB_APPLMODAL,"Error","There are error(s) with the xml code",10)
    winclose("Office RibbonX Editor")
EndIf

 

Edited November 19, 2020 by danmcg
adding extra code to describe my issues

[Danp2]

20 minutes ago, danmcg said:

@SW_MAXIMIZE

Did you try like this?

Call autoit.WinSetState("Office RibbonX Editor", "", autoit.SW_MAXIMIZE)

 

[JockoDundee]

16 minutes ago, Danp2 said:

Did you try like this?

or failing that, like this?

Call autoit.WinSetState("Office RibbonX Editor", "", 1)

 

[mLipok]

as to your topic title:

Quote

Found out how to add reference to AutoItX3.dll, now how can i add the #include in the excel procedure

You could not add #include with AutoItX.
You can only use enlisted function in this part of AutoItX.chm

[danmcg]

thanks dan and jocko. now how do i code for this? $MOUSE_CLICK_LEFT. tried autoit.$ but nothing enumerates. how can i fix this?

 

 

[Danp2]

Then look up the constant value in AutoitConstants.au3 and use that instead.

[JockoDundee]

19 minutes ago, danmcg said:

thanks dan and jocko. now how do i code for this? $MOUSE_CLICK_LEFT. tried autoit.$ but nothing enumerates. how can i fix this?

 

The button to click:     $MOUSE_CLICK_LEFT ("left")     $MOUSE_CLICK_RIGHT ("right")     $MOUSE_CLICK_MIDDLE ("middle")     $MOUSE_CLICK_MAIN ("main")     $MOUSE_CLICK_MENU ("menu")     $MOUSE_CLICK_PRIMARY ("primary")     $MOUSE_CLICK_SECONDARY ("secondary")

so try “left”

[danmcg]

thanks again, both of you. got it figured out.