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..

[DoobieKeebler]

Not trying to be cute here, but the SELECT statement you have should have quotes.

Select * From [SUMMARY$] Where Status = "Open"

If that's not the problem then I'd guess the problem is in another part of your code.
_________________
Always take into account what a user would never ever in a million years do, because someone will.

"In theory, there's no difference between theory and practice. In practice, there is." -- Yogi Berra