Menu

Replacing Access & Excel Macro Apps With a Web App
📰

Replacing Access & Excel Macro Apps With a Web App

DEV Community: laravel·Muhammad Ali Mughal·about 17 hours ago
#2KDnfFPp
#devtolaravel#devto#dev#legacy#file
Reading 0:00
15s threshold

Many profitable businesses still run a critical process on a Microsoft Access database or an Excel workbook full of VBA macros. It started as a smart shortcut. Years later it holds the pricing logic, the customer history and the month-end report, it lives on one shared drive, and only one person really understands it. Replacing it is not a rewrite of screens. It is a migration of data, hidden business rules and daily habits, and that is where most projects fail.

At Loop Origin I build custom web applications on Laravel, Vue, Nuxt and PostgreSQL, and as a Principal Software Engineer I have moved several of these spreadsheet-era systems to the browser. I wrote this with help from AI tools and checked every command and code sample myself. This is the playbook I use.

How do you replace an Access or Excel macro app with a web app?

Direct answer: Inventory every table, form, query, macro and report first.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.