On Thu, 21 May 2020, at 08:27, Ian Stewart wrote:
The company is called More4Apps <https://more4apps.com/> and their products utilize thousands of lines of Visual Basic for Applications ( VBA <https://en.wikipedia.org/wiki/Visual_Basic_for_Applications> ) code running in the Excel spreadsheets they provide.
I've often wondered if they would be better off to switch from using the Excel / VBA combination to Calc <https://simple.wikipedia.org/wiki/OpenOffice_Calc> / PyUNO Bridge <https://wiki.openoffice.org/wiki/PyUNO_bridge> / Python3 and that way they avoid having to use VBA.
Heh as someone who used to run a competing business to More4Apps, also in the Excel/VBA space... We did experiment with the Calc / Uno journey (no Python at the time); it was an expensive and fruitless lesson. VBA was a far better contender, even though it is an antiquated language with a truly lacking IDE. That said, another one of my projects I was able to convert much of my VBA into Python using xlwings. That was a really excellent experience which I'd definitely use again. E -------------------------------------------- Q: Why is this email five sentences or less? A: http://five.sentenc.es On Thu, 21 May 2020, at 08:27, Ian Stewart wrote:
felt compelled to include an interface to Microsoft Excel,...
Interesting that SAP's front end sucks so much that there is money to be made selling Excel as the data entry interface.
It seems that this has also been the case with Orcale ERP. For 20 years a Hamilton based company has been globally selling their Excel data entry front end to Oracles product suite.
The company is called More4Apps <https://more4apps.com/> and their products utilize thousands of lines of Visual Basic for Applications ( VBA <https://en.wikipedia.org/wiki/Visual_Basic_for_Applications> ) code running in the Excel spreadsheets they provide.
I've often wondered if they would be better off to switch from using the Excel / VBA combination to Calc <https://simple.wikipedia.org/wiki/OpenOffice_Calc> / PyUNO Bridge <https://wiki.openoffice.org/wiki/PyUNO_bridge> / Python3 and that way they avoid having to use VBA.
cheers, Ian.
_______________________________________________ wlug mailing list -- wlug(a)list.waikato.ac.nz | To unsubscribe send an email to wlug-leave(a)list.waikato.ac.nz Unsubscribe: https://list.waikato.ac.nz/postorius/lists/wlug.list.waikato.ac.nz