Hey Jeff,
That part's simple enough with a little AppleScript.
------------------------------------------------------------
# Auth: Christopher Stone
# dCre: 2019/09/01 17:46
# dMod: 2019/09/01 17:46
# Appl: Microsoft Excel, Keyboard Maestro Engine
# Task: Extract Value of Selected Cells to a KM Variable
# Libs: None
# Osax: None
# Tags: @Applescript, @Script, @Keyboard_Maestro_Engine, @Excel, @Microsoft_Excel, @Extract, @Value, @Selected, @Cells
------------------------------------------------------------
tell application "Microsoft Excel"
set cellValueList to value of cells of selection
end tell
set AppleScript's text item delimiters to linefeed
set cellValueList to cellValueList as text
tell application "Keyboard Maestro Engine"
setvariable "cellValueList" to cellValueList
end tell
------------------------------------------------------------
This particular code requires a partial or entire (single) column of data selected.
It will also work with one or more columns selected in a single row of data.
Each of these produces a 1-dimensional AppleScript list that's easy to parse.
The script goes further and produces a linefeed-delimited text list for ease-of-use in Keyboard Maestro.
Personally I would try to do this whole job with AppleScript (UI-Scripting ON1 if necessary), but that's a chore beyond the skills of most folks (if it's even possible).
I'd look at the task a little further – but ON1 is over 1.5 GB, and I don't want to fool with installing such a monster – particularly without knowing if it will work on my machine.
-Chris
