Has anyone ever used Excel with Visual Basic or Python to write automated meta titles and meta descriptions?

All tnxxx

No

its not AI, u can't actually automate it, what u can do is use some formulas in excel to make the metas in a specific format.

You could use any automated content writter API combined with VB script to generate a bunch of Metatitles to use in your sites, as long as you feed them maybe with a CSV with a list of keywords.

Personally, I've never done it this way, because many automatic plugins already do this (and it will kill a lot of automation, unless you could create another script to import all the results accordingly in whatever CMS or kind of web development you are currently using).

Yes I did before on one of my softwares before

Not python, but I've used AutoIT + Excel UDF to do this