I am using Excel 2000.
I try to extract data from an external database which stores the data on several thousand pages with different URL addresses. The addresses only differ by one word, i.e. the username :"Klaus" in the following example.
"URL;http://1on1.xxxxxxxx.com/admin/viewaccount.cgi?username=klaus",
How can I put a placeholder in the script instead of "Klaus", like a cell on the same worksheet, so everytime I run the query (by using a macro) it would replace the name "Klaus" with the name which is then in that particular cell?
Please somebody help, I am working on this already for 3 days without sleep!!!
I try to extract data from an external database which stores the data on several thousand pages with different URL addresses. The addresses only differ by one word, i.e. the username :"Klaus" in the following example.
"URL;http://1on1.xxxxxxxx.com/admin/viewaccount.cgi?username=klaus",
How can I put a placeholder in the script instead of "Klaus", like a cell on the same worksheet, so everytime I run the query (by using a macro) it would replace the name "Klaus" with the name which is then in that particular cell?
Please somebody help, I am working on this already for 3 days without sleep!!!