Thanks so much for your reply. You really helped me clarify my thinking.
Let me answer some of your questions, then I will get to looking more closely at those resources you pointed out. They look quite helpful:
What kind of forms does your application cater for? pdf?
Are the forms display only or read/write?
What kind of spreadsheets does your application cater for? excel?
How sophisticated are the spreadsheets? Do they use formulas/totals/etc?
Are the spreadsheets display only or read/write?
What are the other potential target platforms than windows?
Is distribution and installation of an application an issue?
You mention moving to another technology to gain more flexibility - what kind of flexibility do you desire?
First of all, this is all GUI. Our current application is a standalone GUI, in fact. I don't know if that is clear in my original message.
1. Forms GUI and display data from our database ( or default data )
2. Some forms are display only, some are read/write, and some or editable only in certain cases ( based on configuration or other fields in the form ).
3. Spreadsheets look like excel. In fact, we have a special feature that lets the user right click on the SS to export it so that it can be easily pasted into excel. But it is not Excel, it just looks like Excel.
4. Spreadsheets are very simple, with no formulas, etc. If there are totals, they are put into fields that are external to the spreadsheet.
5. As with the forms, some spreadsheets have editable forms, some do not, and some only have editable columns in certain cases. Actually, in our current code, it is implemented as a movable form ( sort of ).
6. the platform we are committed to supporting is Windows. The main reason I was even considering this was because it has been a pain migrating it to Windows 7 from Windows XP. So I thought another technology might be a little easier, and would offer us the selling point of saying that our GUI can run on other OS ( like Mac or Linux, or maybe even on Mobile Devices ). These other platforms are just a pipe dream. The only required one is Windows.
7. Yes, distribution and installation are potential issues. Right now we have an update application that is used to download the changes.
8. When I say "more flexibility", I largely mean more modern and more supported technologies. Here are the issues and pipe dreams I am considering:
a. Cross platform support, as stated above. Right now it is impossible to run our GUI on anything but Windows. I would at least like to be able to more easily port to new platforms, even if it does not work "out of the box".
b. More easily fix some of these Windows 7 issues I am having because I can use a new technology
Yes, a lot of this is more perception then anything else.
Thanks again for your advice and perspective. You were a huge help. Even answering your questions clarified my thinking. Thanks.