Hi ppl!!! Merry Christmas!


I'm trying to do an app in VB6, a search in a textbox in Change event



I have to do a search in a textbox and returns the result in a Listbox, I've done in VBA from Excel and is easy. The problem is that doing this in VB6 or VB.NET. The code does'nt work.

But i think i need call the file right?

Something like this?



Code:
Dim objExcel As Excel.Application
Dim xBook As Excel.Workbook
Set objExcel = New Excel.Application
Set xBook = objExcel.Workbooks.Open("c:\Buscador1.xls")
I upload the file so you can watch it.


Buscador1.zip

PD: Is possible to put an Image control to display the image that is in column D of the table?

http://img687.imageshack.us/img687/7061/sinttulosma.jpg