ops, stil cant work, syntax error....
thankz for ur kindness, CLR...
actually i would like to hav an simple example like this..

(i) a simple excel file with some data
(ii) a simple query in VBA which is linked to the excel and can
retrieve data from excel

thankz again~


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