Automated Copy and Paste from Excel to Any Application

Much broader than pharmacy informatics, but this is a tool that simplifies having to copy and paste a lot of data from excel to any application, especially when the destination forces you to manually copy and paste each value one-by-one. I personally use it regularly in a variety of reporting applications where I am hardcoding a long list of values in a parameter. The script that automates this function is using AutoHotkey, which is an easy program to download and use after using my instructions.

There are three options that I present in this video:
1) Copying and pasting a continuous string into one field (sending no tab and no enter)
2) Copying and pasting values, and sending Tab after each entry
3) Continuously filling values into a form (sending tab and enter)

The hotkey for all of the scripts is windows key +b

All links and files live on this page for your convenience:

[tompijnappel]

I don't understand why this video doesn't have more views. You're a legend. You really took your time to create a nice tutorial with a dedicated webpage + files/assets to it. You're the man!

[lemonysips]

your videos appear as 80% blue/black space with a small box for your slide deck and another small box of your lecture stream