web query

Bukol · Apr 1st, 2002, 04:08 AM

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!!!

Tom Schreiner · Apr 1st, 2002, 04:27 AM

Hi
Try this.
"URL;http://1on1.xxxxxxxx.com/admin/viewaccount.cgi?username=klaus",

Say klaus2 is in sheet1.range("A2")

"URL;http://1on1.xxxxxxxx.com/admin/viewaccount.cgi?username=" & sheet1.range("A2") & """,

Let us know if it works.
Tom

Bukol · Apr 2nd, 2002, 01:20 AM

Bukol · Apr 2nd, 2002, 01:21 AM

Hi Tom,
Didn't work. I get the message "The address of this site is not valid". Any other ideas?

Tom Schreiner · Apr 2nd, 2002, 03:36 AM

Bukol,
See:
http://www.mrexcel.com/board/viewtop...3806&forum=2&2

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 1st, 2002, 04:08 AM	#1
Bukol Board Regular Join Date: Mar 2002 Location: Philippines Posts: 55	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!!!

Apr 1st, 2002, 04:27 AM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi Try this. "URL;http://1on1.xxxxxxxx.com/admin/viewaccount.cgi?username=klaus", Say klaus2 is in sheet1.range("A2") "URL;http://1on1.xxxxxxxx.com/admin/viewaccount.cgi?username=" & sheet1.range("A2") & """, Let us know if it works. Tom

Apr 2nd, 2002, 01:20 AM	#3
Bukol Board Regular Join Date: Mar 2002 Location: Philippines Posts: 55

Apr 2nd, 2002, 01:21 AM	#4
Bukol Board Regular Join Date: Mar 2002 Location: Philippines Posts: 55	Hi Tom, Didn't work. I get the message "The address of this site is not valid". Any other ideas?

Apr 2nd, 2002, 03:36 AM	#5
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Bukol, See: http://www.mrexcel.com/board/viewtop...3806&forum=2&2