Excel – VBA Macros – SQL – ADO – M – Web APIs – JSON – MS Office
Developer – Project Manager – Business Planner – Technical Writer – Problem Solver
I have 33 years of experience automating Excel, mostly with VBA. I've written Excel VBA tools to use SQL and ADO to access corporate data, allow the user to edit it, and write their changes back to the database. I've used Web APIs and JSON-formatted data in Excel VBA. I've used Excel VBA to access web data such as stock price websites. I've created complex user-interface forms to allow the user to fine-tune their requirements each time they run the tool I created for them.
Microsoft Certified Professional, Microsoft Certified Solution Developer, Microsoft Office Specialist (MOS) Excel Expert.