Microsoft VBA on Linux
I use VirtualBox
VMs for Windows 10 obtained from here: https://developer.microsoft.com/en-us/windows/downloads/virtual-machines
You can try out Microsoft Office for 30 days here: https://products.office.com/en-us/try
This maynot be a long term solution, as the trial will expire. Unless you have scripted the setup of the VM/Office, it will be pretty tedious to set it up every time.
Related videos on Youtube
durron597
Hooray 10,000,000 questions! #SOreadytohelp Java Algorithm and Application developer in my not-free time. Lego Jedi the rest of the time. Best Questions: http://stackoverflow.com/q/16950163/1768232 http://stackoverflow.com/q/14900710/1768232 http://stackoverflow.com/q/14739823/1768232 http://stackoverflow.com/q/20482225/1768232 http://stackoverflow.com/q/28238149/1768232 Best Answers: how to stop “JavaFX Application Thread” How do I implement TypeAdapterFactory in Gson? Turn off logback logging for other libraries while in certain class Why does Gson serializes runtime type in list, not specified compile-time type? MoneyFormatter::parseMoney throws MoneyFormatException Is there a better way to traverse a string in java? Reorder four points of a rectangle to the correct order How do I get typeName() from a mock object in a JUnit test? Why can't we switch on classes in Java 7+? Why does wrapping an exception still request try-catch even when adding a throws?
Updated on September 18, 2022Comments
-
durron597 over 1 year
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?
-
durron597 over 9 years@ECarterYoung This is for my personal machine, part of the point is that I don't want to buy a Windows or an Excel license
-
eyoung100 over 9 yearsWhether you use Wine or VirtualBox you will need the Install CD, of at least Office in order to set either way up, and if you use VirtualBox you will need an OS copy. Wine works better with the native Office DLL's also. Hint: If you have a computer with a restore set, use the Serial number inside the VirtualBox. I will say nothing more, except to say that this is legal because you own the PC.
-
Charles Green over 9 yearsYou might be able to use office online, at office.com/start/default.aspx
-