11th April 2006, 01:52 AM
|
|
Member
|
|
Join Date: Jan 1970
Posts: 4,426
|
|
Quote:
|
Originally Posted by marcus25
That's OK CP, I am suscriber to VF guide, have been since the beginning of the service. For $260 a year it is just too good a value.
Being a programmer I have no problem with turning the zipfiles into databases.
I was mostly interested in the results.
I don't use Excel for anything myself, but tried it out of curiosity, and the results I am interested in, will not be downloaded by web query, (well one could do it but ....)
One thing I have to say though, people spend a lot of time learning to use Excel because, initially, it gives a fast result, but in the end learning a proper programming language would be far more beneficial to them. Most of them are relative easy to learn now with built in functions and GUI, not like 20 years ago.
As far as I can see, Excel is just too restricted in handling any sizable datasource, and is woefully slow once you have a decent macro running.
But I suppose if they are happy with it, why not?
Good luck
|
Hi Marcus,
Yes it's the results that I'm downloading via excel macros.
I can bypass the problems with downloading results by formulae.
I see and know that proper programming would achieve a faster result, but for my purposes I need the information in excel because I combine workbooks to achieve a desired result.
I use Access, Excel, Filemaker, and a couple of "other" programs in stages to achieve my objective.
No one programme can do it all from what I gather.
The other problem is creating rankings, which needs a "wad" of advanced coding or a simple spreadsheet formulae and macro. |