Solved

How best to Send to web page and process the result with Access

Posted on 2014-03-06
2
446 Views
Last Modified: 2014-03-06
Hi,

I have used the methods 'followhyperlink' and acCmdOpenHyperLink to launch web pages for user interaction, but now I have the following problem and need so guidance on how best to achieve the result.

I want to use the SMSGlobal facilities to send SMS messages from an Access 2010 app. It is easy enough to construct the http command with signin, password, tomobile etc. The result lauches the website as a blank page and returns a one line result/error message.

I would like to send the link and receive the result from the page back into my application without showing on the users screen the actual webpage interaction how can this be best achieved?
0
Comment
Question by:ynot8669
  • 2
2 Comments
 

Author Comment

by:ynot8669
ID: 39911456
The web page result looks like this:
<html><head><META content="IE=5.0000" http-equiv="X-UA-Compatible"></head><body>OK: 0; Sent queued message ID: 2045e550e7356343 SMSGlobalMsgID:6666903908584126
</body></html>

So I need help with DOM in vba to extract the body text only
0
 

Accepted Solution

by:
ynot8669 earned 0 total points
ID: 39911535
Solved it before getting an answer via:

Function Testit()
 Dim text As String
 text = GetHTML("http://www.smsglobal.com/http-api.php?action=sendsms&user=xxxxxxxx&password=xxxxxxxx&&from=61999999999&to=6188888888text=Hello%20world")
 MsgBox text
End Function

Function GetHTML(sURL)
 ' Create an xmlhttp object:
 With CreateObject("Microsoft.XMLHTTP")
   .Open "GET", sURL, False
   .Send
  GetHTML = .responseTEXT
End With
End Function
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When setting up new project requests for our site, one of the most powerful tools our team has available to use is Axure (http://www.axure.com/). It’s a tool for creating software and web prototypes that can function and interact as if it were the a…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question