3 ms·
Say what you will about Microsoft, but Excel is amazing. I'm no genius, but during my corp years in $LARGE_PHONE_COMPANY the excel macros I was able to write,
by smtddr 14y ago
Say what you will about Microsoft, but Excel is amazing.
I'm no genius, but during my corp years in $LARGE_PHONE_COMPANY the excel macros I was able to write, interfacing with SAP-HR/BW and HP's Quality Center, was a great time-saver and made a lot of things very stream line and less error-prone. All the COM objects that are available to VBscript create crazy possibilities that, really, you could start a whole company just writing macros to stream-line work for other corps.
I really should look into that kind of thing in Open/LibreOffice now that I'm more at home in Linux.
- ConstantineXVI 14y agoDeveloper tools have always been Microsoft's sweet spot. Excel just happens to be targeted at non-developers.
- toyg 14y agoyou could start a whole company just writing macros to stream-line work for other corps Oh, quite a lot of companies started that way. Many of them still do it exactly like that. Worse: for a while the trend was clearly "all these Excel sheets are terrible, let's replace 'em with <SHINY_NEW_CENTRALISED_WEB_SYSTEM>!", but now established web-based software products are busy touting their wonderful Excel add-ins that seamlessly push data back-and-forth from spreadsheets.
- roel_v 14y ago"I really should look into that kind of thing in Open/LibreOffice now that I'm more at home in Linux." You can start with that now, and be done with it by tea time...
- mdda 14y ago{not sure if sarcasm detected} Since LibreOffice embeds macro writing in Python, the environment is pretty rich - even compared to the mighty Excel VBA...