I really, really want to switch to Linux as my everyday OS. However, one of the things I must be able to do for my job is write / fix VBA macros for Excel.
I know LibreOffice has it's own scripting language.. but from the documentation:
With a few exceptions, Microsoft Office and LibreOffice cannot run the same macro code. Microsoft Office uses VBA (Visual Basic for Applications) code, and LibreOffice uses Basic code based on the LibreOffice API (Application Program Interface) environment. Although the programming language is the same, the objects and methods are different.
I suppose one option would be to run real Excel in Wine? Are there any other options?