Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Adella Garcia   on Mar 27 In MS Office Category.

  
Question Answered By: Myrna Brown   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:

General declaration:

Option Explicit

Sub DialOut()
'Run fine with Window 95 not yet experimented in XP
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.

Share: 

 

This Question has 9 more answer(s). View Complete Question Thread

 


Tagged: