Hello
When reading through posts here it seems to be quite common to have multiple workbooks linked together, either with formulas or "joined" by some macro setup.
I have twice been asked to do "larger" (with my references anyway ) applications at work. This means multiple sheets, a few buttons here and there, generating pdf's etc. About 20 pages of VBA code (pasted in Word, no extra line spacing).
As long as it works, I am asked to add and expand this application frequently. I have several times pointed out that I see where this is going and that we need to buy a professional system. Most people agree more or less but it is a costly investment, hence it is denied or postponed to an indefinite future. Sounds familiar?
I want to know what experiences you have from "large" Excel systems. Everything from stories of great success to complete trainwrecks!
I'm guessing that many systems start out as something small, well suitable for Excel. If this works well, it will slowly grow over time, more featured and functionality is added and eventually you have a complete database or a some part of a business system, spread out on multiple Excel workbooks, linked together or working together with VBA.
Bookmarks