All good options David. But there's always a "but"... :-)
A lot of PCs come with software installed. Quite often this is Works and a version of Word... but no Excel, Access or other office app.
Then again, a lot of architects use autocad, which has VBA, on one PC, and a different PC for their admin with office on it.
There are all sorts of reasons to keep the code independent of an application.... Anyway, that's what I'm trrying to do here. It's also been a challenge and a learning experience as well. The whole project just started off as a cross reference!
I did play with a balanced tree type of data base but ended up just using arrays. I'll probably try dictionaries next as I haven't used them before.
Lisa
-----Original Message-----
From: David Smart <smartware.consulting@gmail.com>
To: ExcelVBA <ExcelVBA@yahoogroups.com>
Sent: Sun, Jan 8, 2012 2:51 am
Subject: Re: [ExcelVBA] Sorting in VBA
If I were doing it, the information would be in a database from the start
nd access to it via SQL would do the needed sorting.
Alternatively, it could be kept in Excel and sorted there, and then Word
ould retrieve the information, which would already be in the right order.
As a third alternative, it could be kept in Excel (unsorted) and retrieved
rom there using an SQL interface, which again could do the sorting.
egards, Dave S
[Non-text portions of this message have been removed]
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar