Hello all.
I have query in my excel sheet. Each time when query is activated, I have to put some data i.e. product code, dates "from" and "to" and so on.
I'm trying to do it much simple as possible.
I made second sheet called "data". In cell A1 I have ABCD001 (product code).
In cell A2 I have "01.03.2020"
I made simple macro (I'm not too strong in macros unfortunatelly), where product code is taken from sheet "data", cell A1, something like this:
(PROD_CODE Like '%" & Range("data!A1")
How to do the same but with date?
Also second question.
If table query is starded normally, is asking for sql server password only once. Next times works without passowrd (till file close).
But if I'm doing it through macro - is asking every time for password. Possible to solve that?
I have query in my excel sheet. Each time when query is activated, I have to put some data i.e. product code, dates "from" and "to" and so on.
I'm trying to do it much simple as possible.
I made second sheet called "data". In cell A1 I have ABCD001 (product code).
In cell A2 I have "01.03.2020"
I made simple macro (I'm not too strong in macros unfortunatelly), where product code is taken from sheet "data", cell A1, something like this:
(PROD_CODE Like '%" & Range("data!A1")
How to do the same but with date?
Also second question.
If table query is starded normally, is asking for sql server password only once. Next times works without passowrd (till file close).
But if I'm doing it through macro - is asking every time for password. Possible to solve that?