I was working on some stuff the other day; it was completely boring and monotonous, but I had to grab information from a webpage […] 3 pieces of it and then paste it in to a Microsoft Excel spreadsheet.
The constant switching back and forth was insane.
I wasn’t able to do all this automatically [hands off], but I made it a lot easier.
I wrote an AutoHotKey script to work for me…
I used my keyboards ‘S’, ‘D’ and ‘F’ keys to grab the 3 pieces of information from the web page and after the 3rd piece of information was collected, it inserted it in to the Excel spreadsheet. ‘X’ is the exit key – when your ready to exit, press it.
Simple, organized and clean. Took me a lot less time. And because I’ve to do this periodically – it’s a keeper, but I wanted to share.
It’s very simple.
TrayTip, Status, Copied System,,1000
;;— Enter the data in Excel
WinWait, Microsoft Excel,
IfWinNotActive, Microsoft Excel, , WinActivate, Microsoft Excel,
WinWaitActive, Microsoft Excel,
Just trying to help…