Ok, I can tell you my experience, and if anyone sees this and can comment a better way, please do: I think that you can do the copying of your Excel data in VBA, but the only way I know currently is to have a macro inside the excel workbook, which always lives in there and can copy your data , then execute a jsx file, and somehow pass the data in via clip-board or even a temporary .txt file. The problem with that is that you have to have your workbook macro-enabled, or have a workbook in your excel application which has the macro which can run, but it's the convoluted principle that you have to have this thing in your Excel at all times you want to use it. (As opposed to just running a durn script and not having to open a file with a script inside of it in Excel). The other way I can think of is using AutoHotKey to do pretty much the exact same thing, except instead of messing with Excel-specific VBA stuff, you'd have to mess with AHK script, but not have to worry about macros and workbooks. I think for copying and pasting column cells, you can probably get away with AHK, but this is such unknown territory for me, and like I said, it looks so much easier on Mac, because your applescript can control all the things from one place. This is very limited world-view that I would like to learn more about, I call out all the lurkers to come out of ye shadows to shed some light on this. Actually I believe the great CarlosCanto has much expertise on using Excel and AI together!
... View more