Turning a complex Excel spreadsheet with VBA functions into an online app
September 12, 2008 7:06 AM Subscribe
I want to build a web app based on an Excel spreadsheet using VBA and some Excel Solve functionality. Should I try to build my own online spreadsheet? Or is Microsoft about to release some nifty online development components compatible with Excel and VBA?
posted by Mokusatsu to Computers & Internet (2 answers total) 1 user marked this as a favorite
I have implemented a fairly comprehensive spreadsheet for generating financial plans based on some inputs about investments, personal profile, risk tolerance, financial goals etc. The spreadsheet used the Solve functionality of Excel and some VBA to iterate through Solves in one place. Other than that, there is mostly just a lot of text and simple calculations involving cells.
Now I want to make this into a web application with a spreadsheet interface that allows some dynamic updating of data (not formulae), and maybe a questionnaire front-end instead of simple spreadsheet input. My question is - should I try to invent my own web app spreadsheet (possibly using components) and separate out the complex algorithmic components which would be too cumbersome to re-invent in my spreadsheet? Or is likely Microsoft will Excel-compatible web app components for development and if I wait, I could save myself re-inventing the wheel?
If I don't wait for Microsoft, what are the best tools for creating a web app (it need not be Windows server based).