Web query to text file instead of worksheet?
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Web query to text file instead of worksheet?

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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 ]

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com