Visual Basic Forum for Visual Basic Programmers VB

[warrenquek]

Hi all, im currently doin a school project and im facing problems to
set constraints to the coding connection to excel..

Example:
i hav a spreadsheet call SUMMARY
1 of the column is called Status
There are 3 different Status (Closed, Open, Void)

i wan to display the rows where Status is Open

i try this but it cant work

Select * From [SUMMARY$] where Status = Open

Select * From [SUMMARY$] where [SUMMARY$P = Open]

anyone of you know what is the correct coding to only take information
where the Status is Open??

Thanks in advance to whoever can help..

[warrenquek]

sori dat i post in wrong place..
please go to [link]
thx alot..