Copy File Name in Numbers & Paste to Memory Location Marker
Is there a way I could push a single stream deck button and have this happen?
switch to the Numbers application
move down a cell (down arrow)
copy the file name in that cell
switch back to Pro Tools application
create a memory marker and paste the file name in the clipboard
Any help would be awesome!!!
Christian Scheuer @chrscheuer2023-04-01 08:04:58.783ZHi Mike,
You could start a step at a time creating a macro with the following actions:
-
switch to the Numbers application
use the "Activate App's Main Window" action and set to "Numbers" app -
move down a cell (down arrow)
use the "Press Keys" action and record a Down arrow keystroke. -
copy the file name in that cell
Use these 3 actions to clear the clipboard, hit Cmd+C in Numbers, and then ask SF to wait until the Clipboard has data before proceeding
- switch back to Pro Tools application
use the "Activate App's Main Window" to switch to Pro Tools
Christian Scheuer @chrscheuer2023-04-01 08:06:05.312ZYou could then potentially end by using this action:
Note that you can drag the orange "text" output of the Wait for Clipboard Text action into the "Name" property of the Create Memory Location action.
- Christian Scheuer @chrscheuer2023-04-01 08:07:28.754Z
It's possible though that using this method, you'd need to specify the memory location number for this last action to work, which would be an issue in your case.
Instead, you could automate this part of the process yourself. Here's some videos that show how you could achieve this:
-