Find data on an Excel spreadsheet with VB
 

Hi all, I am trying to manipulate an Excel spreadsheet. I want to search the A column for a string from a text box of vb6 then display it. I can't get it to work in my VB6 app. What am I doing wrong ? [code] Dim mailmwo As Excel.Application Dim mwoBook As Excel.Workbook mwonum = txtScan ...