L
Laphan
Anybody done any work with Excel / VBA / SQL DB?
Can you give me some pointers on how I could do the following all in one VBA
routine:
1) From a cell variable value (ie, user enters a customer code), I query
table A and put the data into a worksheet starting from say cell A1.
2) A blank row is created after the last data line in point 1 above.
3) Using the same cell variable, query table B and put the data into the
worksheet starting from the row after the blank row in point 2 above.
and so on.
Like I've said before I work with ASP all day and know about ADO
connections, commands and recordsets, so is it something similar to this??
Man thanks.
Rgds
Laphan
Can you give me some pointers on how I could do the following all in one VBA
routine:
1) From a cell variable value (ie, user enters a customer code), I query
table A and put the data into a worksheet starting from say cell A1.
2) A blank row is created after the last data line in point 1 above.
3) Using the same cell variable, query table B and put the data into the
worksheet starting from the row after the blank row in point 2 above.
and so on.
Like I've said before I work with ASP all day and know about ADO
connections, commands and recordsets, so is it something similar to this??
Man thanks.
Rgds
Laphan