Halo, im a newbie 2 both VBA and Excel, I was assigned to design a VBA
script which can post query and retrieve data from an excel sheet, is
it possible to do so?..If yes, what is the 1st step should i
follow?....and im a newbie 2 visual basic as well.

Here is an example of my requirements...
Lets said I post a query, Select all employee from emp1 where sex =
female and age 20, and the VBA will retrieve the data from excel
which match the query...

I jus know this can b done by a Java program with a linking to access
by ODBC....

pls...tis is urgent, any1 can help??

thankz.....(^_2)


---
Message posted from http://www.ExcelForum.com/