Re: The problem with not owning the software

On Tue, 31 Dec 2024 02:18:09 -0500, DFS wrote:

On 12/30/2024 7:59 PM, Lawrence D'Oliveiro wrote:

On Mon, 30 Dec 2024 18:58:06 -0500, DFS wrote:
 

If you ever do need to automate office software or build custom
applications, you'll find that MS Office and VBA is extremely superior
to ALL other office software.

 
Unfortunately, no.

 
You have NO idea what you're talking about.
 
 
 > Even Microsoft realizes that VBA is crap, which is why it is offering
 > Python access to Excel users -- at a cost, of course.
 
Python can't come close to replacing VBA (and vice versa of course).

Esri did a good job of replacing VBA.

https://www.esri.com/arcgis-blog/products/arcgis-desktop/3d-gis/arcgis-
desktop-and-vba-moving-forward/?rmedium=redirect&rsource=blogs.esri.com/
esri/arcgis/2016/11/14/arcgis-desktop-and-vba-moving-forward

They had their own scripting language, Avenue, and switched to VBA over 20
years ago,

https://www.esri.com/news/arcnews/fall02articles/new-tool.html


For a while VBA and Python coexisted, but VBA was phased out. Enjoy living
in the past.