Web query to text file instead of worksheet?

Tom Schreiner · Apr 8th, 2002, 06:38 PM

Hi
Does anyone know if you can possibly steer the information from a web query into a text file or database?

With ActiveSheet.QueryTables.Add(Connection:= _
"URL;http://here.there.com/admin/search.cgi?query=.org&field=email", _
Destination:=Range("A1").Value))

Destination:="Somewhere else?"

Thanks, I appreciate it.
Tom

[ This Message was edited by: TsTom on 2002-04-08 17:40 ]

Tom Schreiner · Apr 8th, 2002, 06:42 PM

P.S.

The query in this case is .org
Is there a way to break down the search into seperate queries and still get the sum total of all the information?

Thanks
Tom

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

Apr 8th, 2002, 06:38 PM	#1
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi Does anyone know if you can possibly steer the information from a web query into a text file or database? With ActiveSheet.QueryTables.Add(Connection:= _ "URL;http://here.there.com/admin/search.cgi?query=.org&field=email", _ Destination:=Range("A1").Value)) Destination:="Somewhere else?" Thanks, I appreciate it. Tom [ This Message was edited by: TsTom on 2002-04-08 17:40 ]

Apr 8th, 2002, 06:42 PM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	P.S. The query in this case is .org Is there a way to break down the search into seperate queries and still get the sum total of all the information? Thanks Tom