#Include + variables doesn't work Topic is solved

[Scr1pter]

Hello,

I created an AHK file which only contains variables (for the future also functions).
In my target script I included that ahk file which contains variables.

The 1st ahk file is named Excel-COM.ahk:

Code: Select all

;Excel-COM
xl          := ComObjActive("Excel.Application") ; Active Excel instance
wb          := xl.ActiveWorkbook  ; Active workbook
ws          := xl.ActiveSheet ; Active worksheet
cellArray   := ["A1", "B1", "C1", "D1"] ; List of cells
cell        := cellArray[i] ; Variable which accesses values of the array

The code of AHK file 2 is:

Code: Select all

#SingleInstance force
#Include Excel-COM.ahk
F5::
ws.Next.Select
return

When running ahk file 2, I expect that pressing F5 will switch to the next workbook.
This works, but only 1 time.
E.g. From Sheet1 to Sheet2.
After pressing F5 again, nothing happens.
When manually selecting a worksheet (e.g. Sheet4) and pressing F5 again, it jumps to Sheet2 again.

If my 2nd code is this, it works perfectly.

Code: Select all

F5::
xl          := ComObjActive("Excel.Application") ; Active Excel instance
wb          := xl.ActiveWorkbook  ; Active workbook
ws          := xl.ActiveSheet ; Active worksheet
cellArray   := ["A1", "B1", "C1", "D1"] ; List of cells
cell        := cellArray[i] ; Variable which accesses values of the array
ws.Next.Select
return

Isn't it possible to include variables via include?
I also tried to declare them all as global (in ahk file 1), but the result was the same.

Regards

[mshall]

Use #Include in your function.

My test was
variables.ahk
x=1
y=2

testinclude.ahk
F5::
#Include C:\Users\mshall\Documents\HotKey\AutoHotKey\variables.ahk ; direct file path because it didn't like it originally
MsgBox, %x%+%y%

Results:
A message box that says 1 + 2

[Scr1pter]

Yes, now it works.
I thought the correct way was to use #include in the header.
Seems it depends on its use and content.

Thanks.

Regards