Using a Safe Array in Excel with AutoHotkey

In the below video I show you how you can use a Safe Array in Excel.

You can read a bit more about them here on the AutoHotkey forum

Using a Safe Array in Excel with AutoHotkey

SetBatchLines,-1
#SingleInstance,Force

;********************Excel Safe array***********************************
XL:=XL_Handle(1) ;Connect to Excel
sArr :=xl.Range["a1:L29"] ;Store the content of the array into sArr
;~ MsgBox % IsObject(sArr)
for row in sArr
  for cell in row 
    data.= cell.value ","

MsgBox % Data



;If you want to access it directly, add the .Value 
sArr :=xl.Range["a1:L29"].Value 
MsgBox % sArr[2,2]

 

Comments are closed.