If I were doing it, the information would be in a database from the start
and access to it via SQL would do the needed sorting.
Alternatively, it could be kept in Excel and sorted there, and then Word
could retrieve the information, which would already be in the right order.
As a third alternative, it could be kept in Excel (unsorted) and retrieved
from there using an SQL interface, which again could do the sorting.
Regards, Dave S
----- Original Message -----
From: <1z@compuserve.com>
To: <ExcelVBA@yahoogroups.com>
Sent: Sunday, January 08, 2012 10:27 AM
Subject: Re: [ExcelVBA] Sorting in VBA
>
> Dave,
>
> I can do nothing except agree with you.
>
> So are you sugesting that if I am in Word then I open a seperate
> Excel/Access application.. put the data int new spreadsheets/databases...
> sort it as required... then grab the result and rewrite my original
> array????
>
>
> Lisa
>
>
> -----Original Message-----
> From: David Smart <smartware.consulting@gmail.com>
> To: ExcelVBA <ExcelVBA@yahoogroups.com>
> Sent: Sat, Jan 7, 2012 11:02 pm
> Subject: Re: [ExcelVBA] Sorting in VBA
>
>
>> I don't think the sort there actually can be altered to cope
> with multiple keys
> The sort I pointed to uses a function called QSortCompare to compare the
> andidate values. As such, you simply need to change all calls to that
> unction send it the correct key information (either by concatenation or
> ultiple parameters) and amend the function as needed to check any extra
> eys if you don't use concatenation in the call.
> Should be straightforward enough.
>> Maybe there's a misunderstanding of "keys" here.
> No, no misunderstanding.
>> The reason for the project is not to sort *in* an
> application but to sort items from the VBE.
> Yes, we see that, but why? Both Excel and Access have excellent - and
> ast - sort capabilities. Why would you use a much slower sort method in
> BA when these capabilities are around?
> If you do ever need to sort in applications that don't have sort
> apabilities, then fine, but there's no point in ignoring perfectly good,
> fficient, and well-understood capabilities in the other applications when
> hey are immediately available.
>
> 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
>
> ----------------------------------Yahoo! Groups Links
>
>
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 10.0.1416 / Virus Database: 2109/4128 - Release Date: 01/07/12
>
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