Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Complete Excel App? Advantages?
Is there any inherent advantage in designing an App in Excel with custom
menus, toolbars, worksheet data validation, taking control of the UI from the user etc etc? To me, it appears to be a wasted effort with more time spent keeping the user away from the UI of Excel than developing program logic. However, I am aware that this has/is being done. The Apps I have seen with this setup seem to lack a 'professional' look and feel. What is the logic behind selecting this setup? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Complete Excel App? Advantages?
Just my opinion, but it would appear:
Some people feel like they need to control the user (assumption is the user is dumb, malicious, or a screw up - can't follow instructions). Another factor might be that the process designed into the APP is very sequential and rigid. -- Regards, Tom Ogilvy "George" wrote in message ... Is there any inherent advantage in designing an App in Excel with custom menus, toolbars, worksheet data validation, taking control of the UI from the user etc etc? To me, it appears to be a wasted effort with more time spent keeping the user away from the UI of Excel than developing program logic. However, I am aware that this has/is being done. The Apps I have seen with this setup seem to lack a 'professional' look and feel. What is the logic behind selecting this setup? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Complete Excel App? Advantages?
Hi George,
Is there any inherent advantage in designing an App in Excel with custom menus, toolbars, worksheet data validation, taking control of the UI from the user etc etc? To me, it appears to be a wasted effort with more time spent keeping the user away from the UI of Excel than developing program logic. However, I am aware that this has/is being done. The Apps I have seen with this setup seem to lack a 'professional' look and feel. What is the logic behind selecting this setup? These are commonly known as 'Dictator' applications and are most applicable when you want to create an application that looks and behaves like any other Windows application, but which utilises the powerful features built in to Excel for data entry, analysis and reporting. Most of that analysis is done behind-the-scenes and the intention is to provide the users with a menuing system and user interface that will allow (force?) them to concentrate on the tasks required by the application itself instead of being distracted by trying to remember where and how you want them to enter data. Regards Stephen Bullen Microsoft MVP - Excel www.BMSLtd.co.uk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advantages to Table Feature in Excel 2007? | Excel Discussion (Misc queries) | |||
I want to know the Advantages or benefits of MS Access and Excel? | Excel Discussion (Misc queries) | |||
Advantages of Excel over Pencil and Paper | New Users to Excel | |||
advantages and disadvantages of VBE over excel macros | New Users to Excel | |||
What are the advantages of using Access over Excel? | Excel Discussion (Misc queries) |