I do not know if you have access to this example ( Vee 6 perhaps ? )
But in the example folder there is ExcelAsDatabase.vee what I think does
exactly what you want ?
Should run on VEE 5 also...
On the other hand you can start a macro in excel via vee- should be faster
to get the result then when using large numbers.
Von: Ashley Derrick [mailto:firstname.lastname@example.org]
Gesendet: Mittwoch, 25. Januar 2006 09:40
Betreff: [vrf] Search for Cell in Excel for VEE 5
Does anyone have an Active X example of how to search the first column of an
Excel sheet for a text string . My customer has 1300 rows of test parameter
dataand I need to identify the specific row by its unique text string in
the first row of each column.
I do have Vee code which works fine for this but I wrote it about 8 years
ago and used the DDE function rather than Active X. WhenI used it I only
had about 20 rows of data.
I am using VEE 5.01
Hope someone can help.
You are currently subscribed to vrf as: email@example.com
To subscribe send a blank email to "firstname.lastname@example.org".
To unsubscribe send a blank email to "email@example.com".
To send messages to this mailing list, email "firstname.lastname@example.org".
If you need help with the mailing list send a message to "email@example.com".
Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".