I've converted several Excel apps to other formats and have a pretty quick
(and dirty) way to get started. I'm assuming you will get rid of the Excel
stuff and move to a database. With SQL Server I use the import function to
bring in each sheet as a table. This usually results in a nasty looking DB
and at this point you need to consider if you can cleanup the DB or use it
as is. Clean of course is best, but structural changes will cause
significant changes to the program logic. With your time constraint likely
not a good idea for now. Throw in a few views and SP's to fill the gaps,
and then just drag tables, etc from the server explorer onto your
forms/pages. Dragging a combination of Detail and Grid views can usually
get you pretty close to where you need to be, especilly if your app is
basically a store and retrieve type.
It's an ugly approach, but you can do the basics with an app of that size in
a couple of hours. From there you should be able to estimate how much
effort would be required to finish. For the code conversion if you have
access to a good CASE tool (I like PowerDesigner) you can reverse engineer
your VBA and then change your target to C# and generate your code. This
tool also makes database cleanup pretty easy.
Worst case you can run your app under an application that serves app forms
as web pages. There is one used all the time but I'm drawing a blank on the
name (not enough coffee yet
)
