Why? I have written a lot of custom macros and created forms to assist filling data fields in large spreadsheets. I have written macros that can open a CSV, comb through the contents and pick out the data I need to fill workbooks.
I’m not saying I’m especially tied to VB itself, I actually find it to be a pretty stupid language, but I do miss being able to write my own functions and effectly use Excel as a pre built GUI for whatever I’m trying to do. If there’s an alternative in Libre Office that I’m missing please point it out.
LibreOffice supports python, JavaScript, and beanshell, as well as LibreOffice basic. The latter is similar to VBA and some VB scripts can even run unmodified.
Why? I have written a lot of custom macros and created forms to assist filling data fields in large spreadsheets. I have written macros that can open a CSV, comb through the contents and pick out the data I need to fill workbooks.
I’m not saying I’m especially tied to VB itself, I actually find it to be a pretty stupid language, but I do miss being able to write my own functions and effectly use Excel as a pre built GUI for whatever I’m trying to do. If there’s an alternative in Libre Office that I’m missing please point it out.
LibreOffice supports python, JavaScript, and beanshell, as well as LibreOffice basic. The latter is similar to VBA and some VB scripts can even run unmodified.
https://help.libreoffice.org/latest/en-US/text/shared/guide/scripting.html
Oh cool. Thanks, I’ll check it out.