That’s fair. I’ve dealt with that before, and in my case I had to rebuild the damn thing for compatibility with the web version. When I did, I was able to use alternatives like Power Query M instead of VBA. This worked in my case, but I’m sure you’re right that some features just aren’t there in any capacity.

The external CSV thing is a PITA but you can (at least there) overcome it via adding a “landing sheet” for raw data. Nobody is going to want to deal with any of this, though.