![]() |
|
![]() | ||
|
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. |
![]() | ||
|
There is no answer at this time. |
![]() | ||
|
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. |
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 Home - Answers FAQ - Terms of Service - Privacy Policy |