Viewing profile — sancarn

COM is still actively being used. Not sure why you think it's a problem with windows too. COM is and always has been quite revolutionary imo.

Not sure about other people but most of my apps I've made actually can't be made in Office Scripts... They are useless for my needs.

> good software that exists on other platforms You mean like AppleScript?

> They had announced Python support for Excel a while back and I wish it was better promoted as a viable VBA replacement But the existing implementation of Python means that it's n…

Untested but something like this in VBA should suffice: Dim rng as range: set rng = Sheet1.UsedRange Dim rows as Long: rows = rng.rows.count Dim cols as long: cols = rng.columns.co…

These are the reasons I struggle to leave Windows too. Also the open API ecosystem is great. You can do pretty much everything with win32 libraries.

> At least I have yet to see one that is actually useful in the sense of a generic (or even a single-purpose-built) language Yeah as said, https://github.com/enso-org/enso seems to…

I am consistently frustrated with how limited these visual programming languages are. They are 100% ok, until your problem gets a tiny bit complicated. Then all hell breaks loose. …

Certainly! If you're ever interested in seeing some awesome VBA stuff I have a big list here: https://github.com/sancarn/awesome-vba Lots of awesome stuff still in the VBA/VB6 comm…

In our case (and in the article), we wanted to collaborate with IT, code along-side them in a technology of their choosing. However IT explicitely told us that they would NOT allow…

Actually, every language in theory. At least any language which can use COM APIs can interact with PowerPoint. Ruby, Python, NodeJS, C, C++, C#, Java, Rust, ... Pretty much you nam…

I do RPA from VBA personally using IAccessiblity. See stdAcc ( https://github.com/sancarn/stdVBA/blob/master/src/stdAcc.cls ) and an example ( https://github.com/sancarn/stdVBA-exa…

> they would have to essentially start from scratch if they wanted to do anything else like Python I do tend to disagree here. It really depends how invested they are with VBA. Man…

> so why are you complaining again? Because a job that would take 15 minutes turns into a 3 hour task. It might surprise you but some people actually enjoy their job and ticking of…

I have invested copious amounts of time into building VBA libraries ( https://github.com/sancarn/stdVBA ) and as much as I love vba there are some highly limiting actual problems w…

Good if all you do is display a fancy UI for some data entry or visualisation, but OfficeJS can't do half the things VBA can do unfortunately. If only the addin system had FFI. I'd…

Agree, Python implementation in Excel is trash. Not at all a competitor for VBA. Not yet anyway.

Microsoft recently released OfficeScripts, which are JS with a record macro button. Problem is, it's currently too limiting. Will be good in a few decades though if support isn't d…

Honestly, this is something I've been wanting to do for a while... Last I looked though, I couldn't find many good resources on how WASI (or the byte code) worked... And VBA being …

This is already happening with IT maintained systems though... As specified in the article. So it really isn't an argument imo. IMO, companies should have a language of choice whic…

> We tried to work with them by giving them tools that plugged into Excel This is probably one of the best ideas out there. If companies built a bunch of Excel Addins to leverage b…

To be fair, as an SME, I do have documentation and an architectural overview. In my experience when I have provided these, they have been ignored anyway. I do not have access to gi…

VBScript is deprecated: https://nolongerset.com/vbscript-deprecation/ JScript is deprecated, and is likely to be removed at some point too... CMD is often blocked on many people's …

To be honest, not hard coding a connection string is quite tough too. It really isn't an easy problem to solve. And especially when every piece of software out there connects to da…

I do agree, but they do have their limitations. Can't update sharepoint lists from Excel if you have more than 5000 records, can't update sharepoint lists generally unless you use …