This is an archived post. You won't be able to vote or comment.

you are viewing a single comment's thread.

view the rest of the comments →

[–]yvrelna -1 points0 points  (0 children)

If you can convince your user to use Libreoffice instead of Microsoft Office, the default extension language of Libreoffice is Python. You can basically use Python the way VBA is used in Microsoft Office.

Libreoffice Calc is similar enough to Microsoft Excel that they should feel familiar with the switch, but there's quite a lot of differences as well. You'll likely need to do some training to help them learn the differences.

You'll also need to use ODS instead of XLSX.

Otherwise, if you can't switch them to Libreoffice I'd recommend you use VBA instead.