+ Reply to Thread
Results 1 to 15 of 15

DTMF tone Generator add-in For Excel

  1. #1
    Registered User
    Join Date
    06-04-2011
    Location
    Duluth, MN
    MS-Off Ver
    Excel 2010
    Posts
    15

    Question DTMF tone Generator add-in For Excel

    I'm working for a company that uses an Avaya phone system and we have about 100 voice mail boxes that we have to check twice every day. It is a very labor intensive job because we have to manually dial each number, enter the code, and select from menu options. It would be a real help if we had an Add-in for excel that would read numbers from a cell and generate a DTMF signal.

    Now, I have the ability to connect my computer's audio to the phone, that isn't the problem, but finding a solution like this "on the cheap" (and by that I mean free) seems to be a brick wall.

  2. #2
    Forum Contributor
    Join Date
    06-16-2011
    Location
    London
    MS-Off Ver
    Excel XP
    Posts
    276

    Re: DTMF tone Generator add-in For Excel

    You could try the windows kernal "beep" routine.

    Add this to the declarations section of a module:

    Please Login or Register  to view this content.
    and then call it from a subroutine like so:

    Please Login or Register  to view this content.
    Just change the "4000" to whatever will be the correct tone for the number you want dialed. For example, if you have all your phone numbers stored in the same column as a whole number (eg 5551001) then you would assign each in turn to a string variable and cycle through each number in the string. Like so (and I guarantee that all the frequencies below will be wrong, you'll have to figure out those yourself by trial and error):

    Please Login or Register  to view this content.
    Last edited by swoop99; 04-07-2012 at 08:49 PM.

  3. #3
    Registered User
    Join Date
    06-04-2011
    Location
    Duluth, MN
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: DTMF tone Generator add-in For Excel

    That is a very creative solution indeed. However, each DTMF tone is comprised of two tones played at the same time. For example the number one is expressed as a tone at 1209 Hz on top of 697 Hz. Unless we could play two of these beeps simultaneously it wouldn't work. =(

  4. #4
    Valued Forum Contributor
    Join Date
    06-16-2006
    Location
    Sydney, Australia
    MS-Off Ver
    2013 64bit
    Posts
    1,394

    Re: DTMF tone Generator add-in For Excel

    Have you considered using a DTMF generator (i.e. Skype, and just save all the phone boxes with the relevant pauses and codes as speed dial? Then just dial the numbers one after another.

  5. #5
    Valued Forum Contributor
    Join Date
    06-16-2006
    Location
    Sydney, Australia
    MS-Off Ver
    2013 64bit
    Posts
    1,394

    Re: DTMF tone Generator add-in For Excel

    the other thing to look at is to see if you can route your messages to a federated inbox (i.e. redirect all messages to one mailbox.). Avaya is pretty powerful

  6. #6
    Registered User
    Join Date
    06-04-2011
    Location
    Duluth, MN
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: DTMF tone Generator add-in For Excel

    Have you considered using a DTMF generator (i.e. Skype, and just save all the phone boxes with the relevant pauses and codes as speed dial? Then just dial the numbers one after another.
    I do have a recording of each DTMF signal. However, I lack the VBA skills to make a macro that would play them in sequence. Does anyone know how that would work?

  7. #7
    Forum Contributor
    Join Date
    06-16-2011
    Location
    London
    MS-Off Ver
    Excel XP
    Posts
    276

    Re: DTMF tone Generator add-in For Excel

    Ok, try:

    Please Login or Register  to view this content.
    and

    Please Login or Register  to view this content.
    Last edited by swoop99; 04-08-2012 at 08:43 AM.

  8. #8
    Registered User
    Join Date
    06-04-2011
    Location
    Duluth, MN
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: DTMF tone Generator add-in For Excel

    Is this a macro? Where would I place the sub/end sub?
    Last edited by dymention2; 04-08-2012 at 09:09 AM.

  9. #9
    Forum Contributor
    Join Date
    06-16-2011
    Location
    London
    MS-Off Ver
    Excel XP
    Posts
    276

    Re: DTMF tone Generator add-in For Excel

    In the declaration section (very top) of a module.

  10. #10
    Registered User
    Join Date
    06-04-2011
    Location
    Duluth, MN
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: DTMF tone Generator add-in For Excel


  11. #11
    Forum Contributor
    Join Date
    06-16-2011
    Location
    London
    MS-Off Ver
    Excel XP
    Posts
    276

    Re: DTMF tone Generator add-in For Excel

    Curious.

    Try taking out the 'public'. ie

    Please Login or Register  to view this content.

  12. #12
    Registered User
    Join Date
    06-04-2011
    Location
    Duluth, MN
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: DTMF tone Generator add-in For Excel

    I figured it out, it should look like this

    Please Login or Register  to view this content.
    I spaced out on the Part Safe thing. Anyway, how do I call this function? Do i assign a macro like this? Then assign it to a button?

    Please Login or Register  to view this content.

  13. #13
    Forum Contributor
    Join Date
    06-16-2011
    Location
    London
    MS-Off Ver
    Excel XP
    Posts
    276

    Re: DTMF tone Generator add-in For Excel

    Well that's up to you matey. You mentioned you've got 100 or so voicemail boxes to check so you could try putting all of them in a column and having a for next loop to take each one in turn and dial it's number (plus the voicemail options) and then.....um......do whatever it is you do once you've gotten access to the voicemail. Or you could have it assigned to a button whereby you first select the cell with the voicemail box number in it. Or various other methods.

  14. #14
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: DTMF tone Generator add-in For Excel

    Assuming you have a modem ...

    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate

  15. #15
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: DTMF tone Generator add-in For Excel

    By the way I think the only change needed there for 64bit is to add PtrSafe again.

+ 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