Python for Excel: A Modern Environment for Automation and Data Analysis

Re:Python for Excel: A Modern Environment for Automation and... by andrewlgood on Wednesday July 14, 2021 @08:25AM (#27832279)

Agree. This is why there is so much MS Access stuff out there. It came as part of the MS Office suite so office workers had it on their desktop and could use it without having to IT and work their way up the priority queue.

VBA is terrible, but it is the only programming-like option for most office workers outside of IT/Engineering

[ Parent | on HN ]

Re:Python for Excel: A Modern Environment for Automation and... by TrackerFF on Wednesday July 14, 2021 @08:33AM (#27832333)

Quite relatable.

At work, we want to build a simple database and app to interface against it. Asked our boss, asked the IT guys, got the same answer:

A : "Sure, but it has to be MS Access"

Q : "Why though, PostgreSQL / SQLite/ etc. works fine"

A : "Because we already have MS Access"

Q : "OK - could we at least get [programming language + frameworks] for the interface part"

A : "Use Excel and VBA. We already have that"

[ Parent | on HN ]

Re:Python for Excel: A Modern Environment for Automation and... by syshum on Wednesday July 14, 2021 @12:13PM (#27834729)

wait you asked IT to use something other than Access and they turned you down :rolleyes:

I am on a mission to eliminate Access... the day i can distribute office with out Access will be a glorious day indeed

No IT Dept should be telling users to use Access.....

[ Parent | on HN ]

Re:Python for Excel: A Modern Environment for Automation and... by Finnucane on Wednesday July 14, 2021 @10:03AM (#27833100)

I've had that same conversation, but subsititute FileMaker for Access (no access to Access on a Mac). I can run anything I want on my own Mac, but there's no way to make it shareable with the rest of the office.

[ Parent | on HN ]