+ Reply to Thread
Results 1 to 2 of 2

How can I develope a way of placing phone calls from numbers in Excel

Hybrid View

Launchnet How can I develope a way of... 05-29-2010, 11:28 PM
Launchnet Re: How can I develope a way... 05-30-2010, 10:16 PM
  1. #1
    Valued Forum Contributor
    Join Date
    09-04-2007
    Location
    Ontario, Ca
    Posts
    624

    How can I develope a way of placing phone calls from numbers in Excel

    Hi Everyone . . .

    SHG just posted this possible solution on how to dial a phone from Excel.

    I use MagicJack which connects to my cable. I'm hoping that either MaficJack or some other phone that can be connected to cable can do the job.

    Can someone help me please ?

    The following posted by shg.
    I've used this in the past to dial from Excel, but my modem is no longer plugged into a phone line, so I can't test it now ...


    Declare Function tapiRequestMakeCall _
                      Lib "tapi32.dll" _
                          (ByVal stNumber As String, ByVal stDummy1 As String, _
                           ByVal stDummy2 As String, ByVal stDummy3 As String) As Long
    
    Sub DialNumber(PhoneNumber)
        ' 1. Download MSCOMM32.OCX to WINDOWS/System32 folder
        ' 2. From a command line,
        '   > regsvr32 c:\windows\system32\mscomm32.ocx
        ' 3. Add a reference to Micrsoft Comm Control
    
        If MsgBox("Pick up the phone and click OK to dial " & PhoneNumber, _
                  vbInformation + vbOKCancel, "Dial Number") = vbOK Then
            If tapiRequestMakeCall(PhoneNumber, "", "", "") < 0 Then
                MsgBox "Unable to dial", vbCritical, "Error!"
            End If
        End If
    End Sub
    
    E.g. from the Immediate window,


    DialPhoneNumber "7135551212"

    I hope that this is the correct way to post my request when I've seen info from another post.
    Thanks for helping . . .
    Matt @ Launchnet

  2. #2
    Valued Forum Contributor
    Join Date
    09-04-2007
    Location
    Ontario, Ca
    Posts
    624

    Re: How can I develope a way of placing phone calls from numbers in Excel

    How do I . . .

    1. Download MSCOMM32.OCX to WINDOWS/System32 folder
    2. From a command line,
    > regsvr32 c:\windows\system32\mscomm32.ocx
    3. Add a reference to Micrsoft Comm Control

    I have no idea how this is done.

    Can anyone help me ?

    How do I know what type of phone service is needed to dial numbers. Since, my MagicJack phone is connected to my cable, maybe it could work?

    I am going to try and get in touch with MagicJack to see what they may have to say.

    Help Please

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1