It is with some trepidation that I post this request as I have some difficulty in describing it in one line. So if I've got it wrong I hope someone will put it right.
My client has a very large database. I have successfully written code for Excel in MS VBA which creates and sends a query string through the internet to the database and handles the answer (value or string) when it comes back. In that case the query string and the answer coexist on the spreadsheet in different cells.
He now wants a more complex system where the query string and the answer coexist in the same cell, such that the user can modify the string, send it to the database and see the answer in the same cell. I see this as analogous to having a formula in the formula bar, e.g. "=2^3+6-SQRT(9)", and the answer, "11", in the cell.
In my case the formula bar might contain "=QueryString(GrowthRate, Slovenia, 1Q2004, 3Q2006)" and the cell, eventually, "+12.4%".
This is beyond my ken, so I have to ask firstly whether it is possible and, if so, what kind of solution I should be looking for.
Thanks in Advance.