LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.platformsdk.telephony.tapi_2,microsoft.public.platformsdk.telephony.tapi_3,microsoft.public.win32.programmer.tapi,microsoft.public.win32.programmer.tapi.beta
external usenet poster
 
Posts: 2
Default Where can I find TAPI code/reference for VBA?

Greetings and Merry Christmas!

I am looking for some references and code samples to access TAPI.

Here are the functions I want to find out about.

I am looking for how to Disconnect a call (using TAPI)

How to count the number of rings (is this possible?) and display how many
rings have occurred since dialing.

I would "like" to use excel as the only app I need to use (instead of
switching to dialer to end call). I am trying to make a PIM that I can
customize.

I would alos like to trap "Caller ID" info if possible!

I have not been able to find this info...

I am currently using Phone Dialer 1.50. as my access to tapi.
I am using Excel 2002 and Win XP


Here is my code for making the call:
Option Explicit

Declare Function tapiRequestMakeCall Lib "tapi32.dll" _
(ByVal stNumber As String, ByVal stDummy1 As String, _
ByVal stDummy2 As String, ByVal stDummy3 As String) As Long
Public Const ID_CANCEL = 2
Public Const MB_OKCANCEL = 1
Public Const MB_ICONSTOP = 16, MB_ICONINFORMATION = 64

Function DialNumber(PhoneNumber, Optional vName As Variant)
Dim Msg As String, MsgBoxType As Integer, MsgBoxTitle As String
Dim RetVal As Long
' Ask the user to pick up the phone.
Msg = "Please pickup the phone and click OK to dial " _
& Chr(13) & Chr(13) & PhoneNumber & " " & vName
RetVal = tapiRequestMakeCall(PhoneNumber, "", vName, "")
If RetVal < 0 Then
Msg = "Unable to dial number " & PhoneNumber
GoTo Err_DialNumber
End If
Exit Function
Err_DialNumber: 'This is not an On Error routine.
Msg = Msg & Chr(13) & Chr(13) & _
"Make sure no other devices are using the Com port"
End Function




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Use text from a cell reference in vba code. JackyJ Excel Discussion (Misc queries) 1 October 4th 10 07:57 AM
VBA code for find function (reference cell value) emil Excel Worksheet Functions 0 May 5th 09 01:57 AM
Naming a reference table for use in a VBA Code CAT Excel Discussion (Misc queries) 4 October 2nd 08 01:36 PM
Reference a Column in Code Wally Steadman[_3_] Excel Programming 1 November 17th 03 11:26 AM
Adding reference in code Andrew O'Brien Excel Programming 7 November 4th 03 09:43 PM


All times are GMT +1. The time now is 09:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"