I have an Excel worksheet, with a User Defined Function- that talks to an Access database and returns a single value according to various parameters, its to give my users a very simple way to talk to the database.
Its slooooow. The worksheet has nearly 100 of these in, and it takes over 5 minutes to calculate! (4 minutes if you use vba.calculatefull)
a) is this a daft way to let users look for database values, if so what would be a better way? MS Query proves too complicated, and I'm not convinced 100 of those would be any faster!
b) ways to speed it up? I've read that using C++ to create add-ins would make it faster, but this is all being done in a managed environment, I have no way of installing addins or altering the registry, would this matter?
Also, hi!
Its slooooow. The worksheet has nearly 100 of these in, and it takes over 5 minutes to calculate! (4 minutes if you use vba.calculatefull)
a) is this a daft way to let users look for database values, if so what would be a better way? MS Query proves too complicated, and I'm not convinced 100 of those would be any faster!
b) ways to speed it up? I've read that using C++ to create add-ins would make it faster, but this is all being done in a managed environment, I have no way of installing addins or altering the registry, would this matter?
Also, hi!
