4 ms·
I have similar problems, and the security lockdown and lack of support from the IT department. Here are some various hacks I've found. In roughly increasing o
by BMc2020 5y ago
I have similar problems, and the security lockdown and lack of support from the IT department. Here are some various hacks I've found. In roughly increasing order of difficulty:
1) Clipboard history. Windows key + v to turn it on. Part of windows, no installation required. Then winkey + v shows your recent clipboard items and you can use them over again. You can pin frequently used commands.
1.5) Windows key + R. Open up a simple gui to run 1 line commands. Has a history you can access with the up and down arrows. You can do amazing things in 1 line of DOS.
2) Dos cmd terminal. Part of windows, no installation required. You can make simple scripts called .bat files
3) Powershell. Part of windows, no installation required. Difficult to learn, frozen in place at version 5 I think.
4) Power Automate. Part of Office Online, no installation required (if they use Office 365) Difficult to learn. The whole Power apps community has a lot of potential, depends on your Windows license.
5) Power Automate Desktop. Free from MS for most MS environments. Can do a lot with this. If I had to pick one this would be it.
6) Power FX. An Excel scripting language from MS, but only available in the Excel web version of Enterprise O365. I guess it's a version of typescript, and feels a bit like Power Query. Worth taking a look at so you know it's there.
6.5) Power Query. Part of Excel Desktop. Not for querying, despite the name, but for getting rid of all the crap in excel files. Not faster than doing it yourself, unless you have to clean up the same excel file over and over, then you can save the query and automate that part.
7) Windows365. Like an azure ms desktop, but a fixed price virtual windows 10. Acccess it through your browser, but can share files and clipboard. About USD 40 a month. But, it's just like win10 home, you can install whatever software you want.
8) AutoHotkey Needs your sysadmin admin to allow a 1 time install. Steep learning curve but it's everything your wife wants. Very deep user base and community.
9) Any of the RPA enverionments like UI-Path and so on. Very expensive and needs big corporate buy in. Never tried any so don't know. MS liked 5) PAD so much they bought it and made it free (their SOP to run competitors out of the business) so that tells you something.
Honorable mention: Programable keyboards (send a string when a key is pressed). Never tried one but would like to.
- fomine3 5y agoGreat list! I add Excel VBA.
- airbreather 5y agoLooks like she maybe get python installed by IT, as she is a business analyst, in which case I am thinking pywingui or similar. All the other suggestions are Ok,in their own context, but aren't really going to cut it one way or another. There is no access to command prompt or powershell, the lockdown is like nothing I have ever seen, often if an app is going to be installed or system change made they courier the laptop back to IT and then back again. It's bizarre.