LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.win32.programmer.tapi
external usenet poster
 
Posts: 1
Default Using TAPI in Excel VBA

Andrew,

when you feed a phone number to the phone dialer
through tapiRequestMakeCall it must be in canonical
or plain number format.

If you want to have prefixes dialed you should configure
these in the location settings (Phone and Modem Options).

Best regards,

Matthias Moetje
-------------------------------------
TAPI WIKI: http://www.tapi.info
-------------------------------------
TERASENS GmbH
Augustenstraße 24
80333 Munich, GERMANY
-------------------------------------
e-mail: moetje at terasens dot com
www: www.terasens.com
-------------------------------------

"Andrew" wrote in message
...
I wish to dial telephone numbers from an Excel VBA macro using my PC's
modem. A Google search came up with:
http://www.ozgrid.com/forum/showthread.php?t=16781
and
http://www.mrexcel.com/forum/showthread.php?t=70207
amongst others. Essentially they declare a function to access tapi32.dll:

Declare Function tapiRequestMakeCall Lib "TAPI32.DLL" (ByVal
lpszDestAddress As String, ByVal lpszAppName As String, ByVal
lpszCalledParty As String, ByVal lpszComment As String) As Long

And then use the function:

x = tapiRequestMakeCall(cPhone, "", cName, "")

where cPhone is a string containing the required number. e.g. "0123456789"

This works as expected. The Phone Dialer application pops up two windows
at the top left of the screen, once labelled "Preview" and the other
"Phone Call". However, I actually want to dial 'numbers' including the *
and # characters, for example, to cancel ringback on the BT network by
dialling "#37#" etc. If I enter a non-numeric number the second window
has the title "Internet Call" and the call fails with the message "Failed:
wrong number or the called device is out of service".

I can dial such numbers manually using Phone Dialer where I am able to
select whether I wish to dial as a Phone Call or as an Internet Call.

How can I dial # and * on the modem using TAPI32?



 
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
Where can I find TAPI code/reference for VBA? John[_70_] Excel Programming 3 December 29th 03 10:57 AM


All times are GMT +1. The time now is 08:44 AM.

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"