| Home |
| Search |
| Today's Posts |
|
|
|
#1
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
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming,microsoft.public.win32.programmer.tapi
|
|||
|
|||
|
Where can I find TAPI code/reference for VBA?
"John @johnsonclan.net" <excel_info<nospam schrieb im Newsbeitrag
news:x4IGb.200439$_M.901420@attbi_s54... Greetings and Merry Christmas! Merry Christmas too. I am looking for some references and code samples to access TAPI. See MS TAPI sample from P-SDK. See my TAPI and TSPI FAQ: Q: Is there any sample code available ? http://www.i-b-a-m.de/Andreas_Marschall's_TAPI_and_TSPI_FAQ.htm#_Q:_Is_t here I am looking for how to Disconnect a call (using TAPI) With Assisted Telephony (tapiRequestMakeCall) you can only initiate making a call. You can not control the call (e.g. drop it) via Assisted Telephony. Only the call manager application that actually makes the call can provide further control over that call. If you want full control over a call you have to implement a full TAPI application, i.e. do lineIntializeEx, lineOpen, lineMakeCall and process the LINE_xxx messages. This is the TAPI 2 approach. On W2k, XP and WS2k3 you have additionally TAPI 3 with a COM interface. See samples mentioned above and play around with TAPI Browsers TB20 / TB3x: Q: Where can I download TAPI Browser ? http://www.i-b-a-m.de/Andreas_Marschall's_TAPI_and_TSPI_FAQ.htm#_Q:_Wher e_can Q: Is there a user guide available for TAPI Browser TB20 ? http://www.i-b-a-m.de/Andreas_Marschall's_TAPI_and_TSPI_FAQ.htm#_Q:_Is_t here_1 Q: Is there a user guide available for TAPI Browser TB3x ? http://www.i-b-a-m.de/Andreas_Marschall's_TAPI_and_TSPI_FAQ.htm#_Q:_Is_t here_2 How to count the number of rings (is this possible?) and display how many rings have occurred since dialing. Yes, you should receive a LINE_LINEDEVSTATE (LINEDEVSTATE_RINGING) message: TAPI Service Providers notify applications on each ring cycle by repeatedly sending LINE_LINEDEVSTATE messages containing this constant. For example, in the United States, service providers send a message with this constant every six seconds. Test it with TB20. You have to enable this message by lineSetStatusMessages(). I would alos like to trap "Caller ID" info if possible! You can find the caller ID string at LINECALLINFO.dwCallerIDOffset/Size when LINECALLINFO.dwCallerIDFlags contains LINECALLPARTYID_ADDRESS. You can retrieve this structure by lineGetCallInfo() for a new call and on any changes notified via LINE_CALLINFO(LINECALLINFOSTATE_CALLERID) message. Test it with TB20. It is recommended to post TAPI questions only to the managed TAPI newsgroup: microsoft.public.win32.programmer.tapi -- Best Regards Andreas Marschall Microsoft MVP for TAPI / Windows SDK TAPI / TSP Developer and Tester http://www.I-B-A-M.de/Andreas_Marschall's_TAPI_and_TSPI_FAQ.htm * Please post all messages and replies to the newsgroup so all may * benefit from the discussion. Private mail is usually not replied to. * This posting is provided "AS IS" with no warranties, and confers no rights. |
|
#3
Posted to microsoft.public.excel.programming,microsoft.public.win32.programmer.tapi
|
|||
|
|||
|
Where can I find TAPI code/reference for VBA?
It appears that the links provide info for VISUAL bASIC, BUT not FOR Visual
Basic for Applications. Can I still use the same code sequences? It looks a LOT differenent! TIA "Andreas Marschall [MVP TAPI]" wrote in message ... "John @johnsonclan.net" <excel_info<nospam schrieb im Newsbeitrag news:x4IGb.200439$_M.901420@attbi_s54... Greetings and Merry Christmas! Merry Christmas too. I am looking for some references and code samples to access TAPI. See MS TAPI sample from P-SDK. See my TAPI and TSPI FAQ: Q: Is there any sample code available ? http://www.i-b-a-m.de/Andreas_Marschall's_TAPI_and_TSPI_FAQ.htm#_Q:_Is_t here I am looking for how to Disconnect a call (using TAPI) With Assisted Telephony (tapiRequestMakeCall) you can only initiate making a call. You can not control the call (e.g. drop it) via Assisted Telephony. Only the call manager application that actually makes the call can provide further control over that call. If you want full control over a call you have to implement a full TAPI application, i.e. do lineIntializeEx, lineOpen, lineMakeCall and process the LINE_xxx messages. This is the TAPI 2 approach. On W2k, XP and WS2k3 you have additionally TAPI 3 with a COM interface. See samples mentioned above and play around with TAPI Browsers TB20 / TB3x: Q: Where can I download TAPI Browser ? http://www.i-b-a-m.de/Andreas_Marschall's_TAPI_and_TSPI_FAQ.htm#_Q:_Wher e_can Q: Is there a user guide available for TAPI Browser TB20 ? http://www.i-b-a-m.de/Andreas_Marschall's_TAPI_and_TSPI_FAQ.htm#_Q:_Is_t here_1 Q: Is there a user guide available for TAPI Browser TB3x ? http://www.i-b-a-m.de/Andreas_Marschall's_TAPI_and_TSPI_FAQ.htm#_Q:_Is_t here_2 How to count the number of rings (is this possible?) and display how many rings have occurred since dialing. Yes, you should receive a LINE_LINEDEVSTATE (LINEDEVSTATE_RINGING) message: TAPI Service Providers notify applications on each ring cycle by repeatedly sending LINE_LINEDEVSTATE messages containing this constant. For example, in the United States, service providers send a message with this constant every six seconds. Test it with TB20. You have to enable this message by lineSetStatusMessages(). I would alos like to trap "Caller ID" info if possible! You can find the caller ID string at LINECALLINFO.dwCallerIDOffset/Size when LINECALLINFO.dwCallerIDFlags contains LINECALLPARTYID_ADDRESS. You can retrieve this structure by lineGetCallInfo() for a new call and on any changes notified via LINE_CALLINFO(LINECALLINFOSTATE_CALLERID) message. Test it with TB20. It is recommended to post TAPI questions only to the managed TAPI newsgroup: microsoft.public.win32.programmer.tapi -- Best Regards Andreas Marschall Microsoft MVP for TAPI / Windows SDK TAPI / TSP Developer and Tester http://www.I-B-A-M.de/Andreas_Marschall's_TAPI_and_TSPI_FAQ.htm * Please post all messages and replies to the newsgroup so all may * benefit from the discussion. Private mail is usually not replied to. * This posting is provided "AS IS" with no warranties, and confers no rights. |
|
#4
Posted to microsoft.public.excel.programming,microsoft.public.win32.programmer.tapi
|
|||
|
|||
|
Where can I find TAPI code/reference for VBA?
John,
Broadly speaking, code for Visual Basic will work fine in VBA. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "John" wrote in message news:yBRHb.66388$VB2.130572@attbi_s51... It appears that the links provide info for VISUAL bASIC, BUT not FOR Visual Basic for Applications. Can I still use the same code sequences? It looks a LOT differenent! TIA "Andreas Marschall [MVP TAPI]" wrote in message ... "John @johnsonclan.net" <excel_info<nospam schrieb im Newsbeitrag news:x4IGb.200439$_M.901420@attbi_s54... Greetings and Merry Christmas! Merry Christmas too. I am looking for some references and code samples to access TAPI. See MS TAPI sample from P-SDK. See my TAPI and TSPI FAQ: Q: Is there any sample code available ? http://www.i-b-a-m.de/Andreas_Marschall's_TAPI_and_TSPI_FAQ.htm#_Q:_Is_t here I am looking for how to Disconnect a call (using TAPI) With Assisted Telephony (tapiRequestMakeCall) you can only initiate making a call. You can not control the call (e.g. drop it) via Assisted Telephony. Only the call manager application that actually makes the call can provide further control over that call. If you want full control over a call you have to implement a full TAPI application, i.e. do lineIntializeEx, lineOpen, lineMakeCall and process the LINE_xxx messages. This is the TAPI 2 approach. On W2k, XP and WS2k3 you have additionally TAPI 3 with a COM interface. See samples mentioned above and play around with TAPI Browsers TB20 / TB3x: Q: Where can I download TAPI Browser ? http://www.i-b-a-m.de/Andreas_Marschall's_TAPI_and_TSPI_FAQ.htm#_Q:_Wher e_can Q: Is there a user guide available for TAPI Browser TB20 ? http://www.i-b-a-m.de/Andreas_Marschall's_TAPI_and_TSPI_FAQ.htm#_Q:_Is_t here_1 Q: Is there a user guide available for TAPI Browser TB3x ? http://www.i-b-a-m.de/Andreas_Marschall's_TAPI_and_TSPI_FAQ.htm#_Q:_Is_t here_2 How to count the number of rings (is this possible?) and display how many rings have occurred since dialing. Yes, you should receive a LINE_LINEDEVSTATE (LINEDEVSTATE_RINGING) message: TAPI Service Providers notify applications on each ring cycle by repeatedly sending LINE_LINEDEVSTATE messages containing this constant. For example, in the United States, service providers send a message with this constant every six seconds. Test it with TB20. You have to enable this message by lineSetStatusMessages(). I would alos like to trap "Caller ID" info if possible! You can find the caller ID string at LINECALLINFO.dwCallerIDOffset/Size when LINECALLINFO.dwCallerIDFlags contains LINECALLPARTYID_ADDRESS. You can retrieve this structure by lineGetCallInfo() for a new call and on any changes notified via LINE_CALLINFO(LINECALLINFOSTATE_CALLERID) message. Test it with TB20. It is recommended to post TAPI questions only to the managed TAPI newsgroup: microsoft.public.win32.programmer.tapi -- Best Regards Andreas Marschall Microsoft MVP for TAPI / Windows SDK TAPI / TSP Developer and Tester http://www.I-B-A-M.de/Andreas_Marschall's_TAPI_and_TSPI_FAQ.htm * Please post all messages and replies to the newsgroup so all may * benefit from the discussion. Private mail is usually not replied to. * This posting is provided "AS IS" with no warranties, and confers no rights. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use text from a cell reference in vba code. | Excel Discussion (Misc queries) | |||
| VBA code for find function (reference cell value) | Excel Worksheet Functions | |||
| Naming a reference table for use in a VBA Code | Excel Discussion (Misc queries) | |||
| Reference a Column in Code | Excel Programming | |||
| Adding reference in code | Excel Programming | |||
![John[_70_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
