Re: Javascript instead of VBscript
Excel uses VBA.
I just noticed O365 Spreadsheets can use TypeScript - in "Office Scripts" rather than macros.
32 publicly visible posts • joined 6 Jul 2021
The authors of the study that coined the term aphantasia said in their result discussion that "we hypothesised that individuals with aphantasia and hyperphantasia would differ in occupational preference, with a bias toward the sciences among those with aphantasia." And their summary by occupation did find lots of Boffins.
https://ore.exeter.ac.uk/repository/bitstream/handle/10871/120508/Phantasia%20Cortex%20revision%2031.3.20%20for%20submission.pdf?sequence=2
Lots of models are out there under "RPA adoption" or "Citizen Developer" programs" and "Centers of Excellence" (CoE) but it requires management changes that include IT and Business to get together and start proofs of concept (PoC) and Pilot projects.
One example to search for: "Microsoft Power Platform Center of Excellence (CoE) Starter Kit"
As a user of Microsoft "Power" things in a locked down org with enterprise apps, I don't see room for a lot of "citizen developer" things (as in all the webinars and ads) happening.
It's still a techie activity even if you're plugging Lego blocks together. If you don't understand data types and control structures or text munging, it's going to be tough. And if you can't do local installs or manage user access, IT holds the keys.
I evaluated RPA tools and for instance, Automation Anywhere? Local Admin rights is needed - the run agent on your machine wants to update on a daily basis. For the case of automating cloud apps, there are more possibilities for the citizen dev, but I don't see that for desktop apps.
In the "HeadFirst Java" book published at about the Millenium, one of the first exercises is a buzzword phrase generator. It sounds pretty much the same - you're just trolling us with the Generation aspect.
Here is my personal portfolio website with a web version of the generator (did that back when I thought some manager 20 years younger than me might hire me).
https://gae-gcs-servlet.appspot.com/hello
As a Notes consultant, I went to a MS Sponsored Sharepoint Training in 2000. What a shitshow! I noticed you needed 4 servers stood up running handfuls of apps to do what 1 Notes server does. And how to build an app? That's another 4 day course. Building Notes apps was a lot like using HyperPad.
Of course Microsoft just plowed them under with slick GUI and marketing efforts.
One of the downfalls was that Anybody could build an app, and they did! What horrors.
Replication of a single database all over is genius.
Actually, I do think there is a "move to next marked document" action in Notes views, similar to "next unread" and I liked using that very much, but I never can find the icon to put it in my view toolbar. Another UI fail, those dodgy "smart icons" that hide and show in random context.
Since in the US of A, rural folk get a much bigger Senate vote than everyone else, this problem persists. Two Senators per state was the deal with the devil that has perpetuated plantation politics in a more urban nation. There are quite a few states with only enough people to get 1 congress representative that still get 2 Senators.
Yes, I was learning COBOL, which made sense. Also C and Unix with bourne shell, which also made sense.
Then they showed us how to run COBOL programs in JCL. Nothing makes sense there. That took my brain offline from learning COBOL.
Powershell reminds me a little of JCL, it makes a tad more sense, but hard to bludgeon your way forward like you can in *nix shells.