Google Answers Logo
View Question
 
Q: need to do an http request in Excel VBA ( No Answer,   1 Comment )
Question  
Subject: need to do an http request in Excel VBA
Category: Computers
Asked by: wizardofyendor-ga
List Price: $10.00
Posted: 13 Jul 2002 15:18 PDT
Expires: 13 Jul 2002 19:14 PDT
Question ID: 39320
I'm looking for a really simple Excel VBA subroutine that will do the
following:

1) do an http GET request for a specific URL

2) read a single parameter / line of text from this URL

3) store the line of text in a variable.

4) I DO NOT need to update the remote web page from excel.  Just
connect, suck in the line of text, store in a variable, and that's
all.

5) I DO NOT want to use Excel web queries, since they throw ugly error
messages if the connection fails.  This subroutine needs to work
entirely in the background and not display anything to the user.

6) Ideally, this subroutine should work on a plain-vanilla
installation of excel 97 or later, and not require any special plugins
or libraries.  However, if it only works on plain vanilla Excel 2000
and later, that's acceptable.

I got as far as http://www.15seconds.com/issue/991125.htm, which has a
rather complicated example.  I'm sure there's a simpler way to do it.
Answer  
There is no answer at this time.

Comments  
Subject: Re: need to do an http request in Excel VBA
From: gils-ga on 13 Jul 2002 18:09 PDT
 
Well, after quite a lot of research and testing I did with Excel and
VBA, I can offer the following:

http://www.vbsquare.com/articles/cgi/

Ignore most of the text and look and the small example toward the end.

One thing is that you will need to add msinet.ocx to your toolbox and
create a form with the Inet control. Add the ocx by right clicking
somewhere in the toolbox area.

I could find the ocx on my W98 system, but not on W2K. I.e. if you
need it for W2K it won't be that simple, or you can ship the ocx from
W98.

Hope this will help.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy