Hi Everyone . . .
SHG just posted this possible solution on how to dial a phone from Excel.
I use MagicJack which connects to my cable. I'm hoping that either MaficJack or some other phone that can be connected to cable can do the job.
Can someone help me please ?
The following posted by shg.
I've used this in the past to dial from Excel, but my modem is no longer plugged into a phone line, so I can't test it now ...
Declare Function tapiRequestMakeCall _
Lib "tapi32.dll" _
(ByVal stNumber As String, ByVal stDummy1 As String, _
ByVal stDummy2 As String, ByVal stDummy3 As String) As Long
Sub DialNumber(PhoneNumber)
' 1. Download MSCOMM32.OCX to WINDOWS/System32 folder
' 2. From a command line,
' > regsvr32 c:\windows\system32\mscomm32.ocx
' 3. Add a reference to Micrsoft Comm Control
If MsgBox("Pick up the phone and click OK to dial " & PhoneNumber, _
vbInformation + vbOKCancel, "Dial Number") = vbOK Then
If tapiRequestMakeCall(PhoneNumber, "", "", "") < 0 Then
MsgBox "Unable to dial", vbCritical, "Error!"
End If
End If
End Sub
E.g. from the Immediate window,
DialPhoneNumber "7135551212"
I hope that this is the correct way to post my request when I've seen info from another post.
Bookmarks