Hi Chaps,
I'm back for more!
I would like to be able to click a button and open a xls file, from within that file, I would like the program to search a certain column (not named, just letter) for the line that contains a same 4 letter alphanumeric code as one of the textboxes on my main form. When it finds a match, it then takes the values from several other columns on the same line, and put's them in seperate textboxes.
Now, I'm happy with openfiledialog (ish!) but suspect that this won't cut it... and as for the searching etc, I really have no idea where to start.
Any ideas, or code, greatly appreciated!
Cheers
Alun
I'm back for more!
I would like to be able to click a button and open a xls file, from within that file, I would like the program to search a certain column (not named, just letter) for the line that contains a same 4 letter alphanumeric code as one of the textboxes on my main form. When it finds a match, it then takes the values from several other columns on the same line, and put's them in seperate textboxes.
Now, I'm happy with openfiledialog (ish!) but suspect that this won't cut it... and as for the searching etc, I really have no idea where to start.
Any ideas, or code, greatly appreciated!
Cheers
Alun