3 ms·
My first job out of University was working for a large US custodial bank (not in the IT dept). We were responsible for monitoring corporate actions happening on
by VBprogrammer 7y ago
My first job out of University was working for a large US custodial bank (not in the IT dept). We were responsible for monitoring corporate actions happening on the securities held by their clients and accounting for the proceeds.
Most of the work was done in some old IBM 390 terminal emulators. The work flow was generally scrape a bunch of information from the terminal into Excel. Reformat it and figure out any discrepancies. Copy some adjustments into another workbook which would automatically enter the data into some screen or other in the terminal emulator to fix the discrepancies.
Someone had built a COM object which could be scripted quite easily in Office VBA. I found a few of the scripts they had written for it hadn't been protected and quickly learned to write my own.
It was kinda fun in its own way.