Hi all
I want to write a program. A quotation program. A quotation program that works out prices for buildings. Mainly steel framed & clad buildings. Its what we do.
I am in a pickle as to whether an excel spreadsheet (maybe with some VBA backend) or an access database (will loads of VBA backend) is the better choice.
I am fairly familiar with access VBA but not familiar at all with excel VBA.
I am fairly familiar with both access & excel and can see that excel would be a good choice as cell values are instantly recalculated based on changes to other cells. However i know how much more scope there is with access but there is a lot of VBA code to write to make it do recalculations to other tables/queries/values/fields/combos/text boxes etc etc etc.
If i used excel for example is it possible to override a calculation in a particular cell by telling it to ignore its formula ? (ie if it calculates the number of purlins is 48, but i want it to be 56) Baring in mind that the worksheet will be locked or protected so that users can't inadvertantly delete a cells formula.
A colleague had developed a very basic spreadsheet a few years ago that i have attached. I started work on an access version myself over a year ago but got too busy to go any further with it. I also began to realise how much work would be involved in doing an access version !!
So if anyone has experience in both access & excel and has an idea of what i want then i would appreciate some guidance.
Thanks in advance.
I want to write a program. A quotation program. A quotation program that works out prices for buildings. Mainly steel framed & clad buildings. Its what we do.
I am in a pickle as to whether an excel spreadsheet (maybe with some VBA backend) or an access database (will loads of VBA backend) is the better choice.
I am fairly familiar with access VBA but not familiar at all with excel VBA.
I am fairly familiar with both access & excel and can see that excel would be a good choice as cell values are instantly recalculated based on changes to other cells. However i know how much more scope there is with access but there is a lot of VBA code to write to make it do recalculations to other tables/queries/values/fields/combos/text boxes etc etc etc.
If i used excel for example is it possible to override a calculation in a particular cell by telling it to ignore its formula ? (ie if it calculates the number of purlins is 48, but i want it to be 56) Baring in mind that the worksheet will be locked or protected so that users can't inadvertantly delete a cells formula.
A colleague had developed a very basic spreadsheet a few years ago that i have attached. I started work on an access version myself over a year ago but got too busy to go any further with it. I also began to realise how much work would be involved in doing an access version !!
So if anyone has experience in both access & excel and has an idea of what i want then i would appreciate some guidance.
Thanks in advance.