Probably Easy. Change column variable?

[eblanc]

I have a long script, that will pull info from COM EXCEL, I won't get you guys bored with all the numbers here. But here's the simplified problem I'm trying to solve.

Code: Select all

%Cam1::
Combojget= "Excel file"
send, excel value from("B2").value
send, excel value from("B4").value
send, excel value from("B8").value
send, excel value from("B10").value
send, excel value from("B12").value

Cam 1 pulls data from column "B"

I would like to do something like
%cam2 pulls data from column "C"
%cam3 pulls data from column "D"
%cam4 pulls data from column "E"

So I'm guessing I should make the column value a variable, But I'm not sure how I would link it?

[TheDewd]

You want something like this?

Code: Select all

#SingleInstance, Force

XL := ComObjActive("Excel.Application")

F1::
	XLGetValues("B")
return

F2::
	XLGetValues("C")
return

F3::
	XLGetValues("D")
return

F4::
	XLGetValues("E")
return

XLGetValues(Column) {
	Global XL

	Send, % XL.Range(Column "2").Value
	Send, % XL.Range(Column "4").Value
	Send, % XL.Range(Column "8").Value
	Send, % XL.Range(Column "10").Value
	Send, % XL.Range(Column "12").Value
}