Closing IExplorer window after sending SMS

[ReidarT]

I am using a form to send a SMS to cellphone-users.
To do this I have to open a URL with parameters.
I do not need to see the IExplorer window at all and I want to close it
automatically after SMS is sent
regards
reidarT

 

['69 Camaro]

Hi.

From reading your post, it's not clear whether you are using Microsoft
Access to automate this or not. If you are using Access, then which method
are you using? There are quite a few ways to open Internet Explorer from
Access, but not all of them allow one to keep it invisible and close it
automatically when finished.

If you are not using Microsoft Access, which is the database application
from the Microsoft Office productivity suite, then I suggest that you post
your question in a News Group for the application that you are using to send
the form, since this News Group is dedicated to issues dealing with
programming Microsoft Access form objects.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[User]

sounds like you should try out "msxml" and the "xmlhttprequest" object

http://www.microsoft.com/downloads/details.aspx?FamilyID=3144b72b-b4f2-46da-
b4b6-c5d7485f2b42&DisplayLang=en

(beware of line breaks in the URL)

 

[ReidarT]

I am using Access to do this and the code is as follows:
..
Private Sub cmdOLBAgent_Click()
Dim strurlOLBA As String
strurlOLBA = Me.OnlineBookingAgent
CreateHyperlink Me!cmdOLBAgent, strurlOLBA
End Sub

Sub CreateHyperlink(ctlSelected As Control, strAddress As String)
Dim hlk As Hyperlink
Select Case ctlSelected.ControlType
Case acLabel, acImage, acCommandButton
Set hlk = ctlSelected.Hyperlink
With hlk
If Not IsMissing(strAddress) Then
.Address = "http://" & strAddress
Else
.Address = ""
End If
End With
Case Else
MsgBox "The control '" & ctlSelected.Name _
& "' does not support hyperlinks."
End Select

End Sub

regards
reidarT