Re: The problem with not owning the software

On 12/31/2024 1:08 PM, Chris Ahlstrom wrote:

Andrzej Matuch wrote this post while blinking in Morse code:
 

On 2024-12-31 02:18, 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).

 AI Overview:
      While both Python and Visual Basic for Applications (VBA) can be used for
     automation, Python is generally considered a more versatile and
     general-purpose language, making it better for complex tasks beyond just
     Microsoft Office applications, whereas VBA is specifically designed to
     automate tasks within Microsoft Office programs like Excel and Word, making
     it ideal for simpler, application-specific automation within that
     environment.
 Examples: NumPy, SciPy, STUMPY, Pandas.
 On the other hand:
      https://github.com/sancarn/awesome-vba

Thanks for that great link.  I haven't written any meaningful VBA code in years, but it helps make MS Office the only office software worth considering if you need custom applications.