Consulting

Results 1 to 4 of 4

Thread: Sound Files with Mac Excel Solution

  1. #1
    Mac Moderator VBAX Guru mikerickson's Avatar
    Joined
    May 2007
    Location
    Davis CA
    Posts
    2,776

    Sound Files with Mac Excel Solution

    Playing sound files from Mac Excel is challanging. All routines I've seen for playing sound files rely on Windows API functions, that aren't on a Mac.

    So I put together this workbook that allows the user to select a sound file and have it played.

    Its been tested on the sound files included with Office, the sounds that come with OS X and the iTunes library.

    (It took me a while to find where stuff was stashed, here are some file paths
    Applications > MicroSoftOffice 2004 > Office > Sounds > many
    MacintoshHD > System > Library > Sounds > several
    merickson > Music > iTunes > iTunesMusic > artist files)

    It works by having Excel write AppleScripts as strings and use the VBA function, MacScript.

    In this example workbook, the user chooses a file. it is opened with QuickTime Player which plays the selected file.

    You should check that the file path Applications>QuickTime Player.app matches your situation. If not, the function scriptOpenFile needs to be modified.

    When you open the file, press the button, which calls Main.

  2. #2
    I know this has been a while, but I can't find the example workbook metionned in the previous post. Is it possible that it was removed or something?

  3. #3
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,217
    Location
    Unfortunately during an upgrade in the software almost all workbooks were removed, hence some of the threads will not make any sense at all.
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  4. #4
    Thanks Aussiebear, I figured, but I still thought I should ask just in case.

Posting Permissions

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