HTTP post in VBA is it possible?

B

BrianElson

I have tried looking everywhere and either it is
imposible with VBA or I am being dumb. In order to
circumvent the Outlook Object model guard I am going to
send hourly status pages to the pager companies web page.
The instructions on the companies web page says this
For One-Way Customers:
HTTP POST to http://www.Arch.com/cgi-bin/wwwpage.exe
Values are:
PIN: This is either a 10 or 7 digit number.
MSSG: This is the text part of the message.
Q1: Q1=1 will echo the message; Q1=0 will not.


Any help would be appreciated.
Thanks
Brian Elson
 
B

brianelson

I got it to work using the following code below. The only
problem know is it pops up a broswer window each tim eif
it says fale or once only if it says true.
txtMessage = "Test"
PagerNumber = "2087375364"
fulltest = "PIN=" & PagerNumber & "&MSSG=" & txtMessage
& "&Q1=0"


ThisWorkbook.FollowHyperlink "http://www.Arch.com/cgi-
bin/wwwpage.exe", , True, , fulltest, msoMethodPost

Any one know how how to close a internet explorer windwo
in VBA???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top