I see separate apps that auto dial your bluetooth to pc connected cell
phone
but is there an interface available for Excel and vba?

The client wants Excel to auto dial his cell phone when he clicks a
phone number link.

Thank you.

Hi Howard

I'm reasonably certain that Broadband ( ADSL & Cable ) operate at a
different frequency to standard Dial Tone meaning unless your client is
using Dial-up, you would have to employ something like Skype to act as
the dialer.

I found this article that uses Windows Dialer to pass a string to Skype:

http://www.dailyfreecode.com/forum/p...vba-25096.aspx

Answer #7 Answered By: Myrna Brown Answered On: Mar 27

I don't know how far my suggestion gonna help u. Sometime back I had
copied a code on pc-phone which is as under:


'Run fine with Window 95 not yet experimented in XP

Sub DialOut()

Dim strDial As String
Dim intReturn As Long

strDial = ActiveCell.EntireRow.Columns("B").Value

intReturn = Shell("C:\Windows\Dialer.exe", 1)
'\ verify correct path and check for the exe file of SKYPE and
substitute in the above given line.

Application.SendKeys (strDial & "%d")

End Sub

Now add one command button in excel (Edit text as Dialer or whatever u
want) . right click and assign macro (macro name - DialOut)
Copy and paste the code in the module.

How it works?

Add the name and the phone number (pls chk the format of phone number
of the skype) in the same sheet of command button. Select cell in a row
on sheet (say Sheet 1) that contains a name and phone number.

Click on the Dial button and Excel will start the Dialer applet and dial
the phone number in column B of the Row.

Note: This works fine with Window 95 dialer applet.

It's very simple VBA macro that uses Shell and SendKeys commands to dial
a phone number using the Windows95 dialer applet. You need not have to
configure anything in control panel.


Good luck

HTH
Mick.

Crikey, I'm on a roll tonight.

Apologies OldYork90, was looking at another Poster who's name was Howard
and confused his name with this post..

Mick.