hi,
Question:
for this problem assume that we've made the connection with OLEDB -EXCEL file.
i've one form. in which there are 3 textboxes and 1 button.
INPUTS:
1st textbox: collumn number of the XLS file. for example [A]
2nd textbox: Row number of the XLS file. for example [4]
so my cell will be A4 (by concatination of the text values of the 1st and 2nd textboxes).
now press the button.
OUTPUT:
3rd textbox.: i want the value of the cell (in this case its A4) in the textbox3.
please reply as soon as possible.
even if you know that how to use the variable in the query without using stored procedures.
i want to use the variables in the query which is written in the code-view if the form only.
as i'm using OLEDB, i wont be able to goto sql server and so i wont be able to use the stored procedures.