AndrewKent
Well-known Member
- Joined
- Jul 26, 2006
- Messages
- 889
Hi there,
I am currently building a program in Excel, which can carry out numerious tasks. Having over 15 userforms, countless macros and several worksheets of caculations in the background, basically all geared towards capturing customer data, producing a application form and submitting the data to an ".mdb" file.
Now everything is going well so far with little in the way of problems and the document is 2.5Mb in size (users centrally access this Read Only). I'm conducting a daily Clean Project on this but I have a few questions...
1) how far can I push an Excel workbook in terms of size/content before it becomes unstable
2) are there any tips that can be offered for program stability
3) Has anyone built anything on this scale before where they would be able to offer advice on the two questions above
...the reason I ask is the program could potentially double in size over the next 6 months depending on the volume of application types it is able to produce. I want to make sure I have considered stability. Many thanks,
Andy
I am currently building a program in Excel, which can carry out numerious tasks. Having over 15 userforms, countless macros and several worksheets of caculations in the background, basically all geared towards capturing customer data, producing a application form and submitting the data to an ".mdb" file.
Now everything is going well so far with little in the way of problems and the document is 2.5Mb in size (users centrally access this Read Only). I'm conducting a daily Clean Project on this but I have a few questions...
1) how far can I push an Excel workbook in terms of size/content before it becomes unstable
2) are there any tips that can be offered for program stability
3) Has anyone built anything on this scale before where they would be able to offer advice on the two questions above
...the reason I ask is the program could potentially double in size over the next 6 months depending on the volume of application types it is able to produce. I want to make sure I have considered stability. Many thanks,
Andy