December 25th, 2012 03:51 PM
Search in VB6 or VB.net from excel
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?
I upload the file so you can watch it.
Dim objExcel As Excel.Application
Dim xBook As Excel.Workbook
Set objExcel = New Excel.Application
Set xBook = objExcel.Workbooks.Open("c:\Buscador1.xls")
PD: Is possible to put an Image control to display the image that is in column D of the table?
Click Here to Expand Forum to Full Width