how to get Excel cell information in VB

[Obear]

Hi all, just a quicky, ive tried useing some samples but cant seem to get it to work so i thoguth i would ask here.

If i want to search a perticular cell in excel and retreive the information stored there, what would be the command line?

thanks for your time

[phinds]

the VB/Excel tutorial project at the link below my name will show you how to do that, but if you think it can be done in one line you should stop now as you are wasting your time.

[lintz]

If you want to display the contents of an Excel cell in VB use the below.

Text1 = objExcel.Range("A10").Value