Ways to insert background music that can be played automatically in Excel

The existing online comparison of several types of Excel automatically play background music programs have the following:

1. Use similar controls such as Windows Media Player, WebBrowser, etc.

The disadvantage is that embedding audio files is not supported, which means that Excel files require wanted to carry additional audio files with them to play properly. And part of the need for VBA programming code support.

2, the insertion of the object, insert the audio file object can be embedded in the file, but does not support AutoPlay. If you need to get music to play automatically, you need to programmatically invoke the OLEObject Verb:=xlprimary method to activate the embedded object, and open the extra window of the media player, which is not very user-friendly.

3, the same way to insert the object, but on the basis of the above scheme, through the programming call API, to read the OLEObject object embedded content to play directly. The advantage is that the Media playback window mentioned above does not appear, with the disadvantage that it requires complex VBA code, and that different formats of audio require different programming code.

4, in addition to the above methods of other VBA programming implementation, usually need to call the Windows API, programming is relatively complex, not suitable for ordinary users.

These programs believe that the average user will be dizzy, not VBA can hardly achieve, then there is no simpler way? Please listen to me slowly.

Many people know how to insert a flash document in PPT or Excel, and Flash animations can play automatically when you open a file. But the flash just as animation is more narrow, in fact, in a different perspective, Flash is a multimedia platform, you can play video animation, of course, can also play audio. The audio file into flash and then inserted into Excel, you can achieve this article mentioned in the Excel background music features.

Successful cases are as follows: Http://pan.baidu.com/s/1fGdXW

The flash controls can be reduced to unnoticed or even invisible.

To make the audio file into a flash file, do not imagine the complex, in fact, is also very simple. There are several options that can be tailored to suit your situation:

Option 1, use audio Flash software, there are many online, recommend a MP3 to SWF Converter, you can download here:

MP3 to SWF Converter 2.4 Green version SWF audio conversion software free download

Software can convert audio files (including MP3 and WAV) to flash playback files, you can set the automatic playback and loop playback, you can set whether the control interface (as background music, do not need to control the interface), as shown in the following figure:

Program 2, direct use of flash software production, but also very simple, first open flash a new project, and then import audio files to the library, and then select the first frame, set the sound and loop playback can (also set the number of repeat playback), and then you can generate SWF files. As shown in the following illustration:

Scenario 3, some people will use Camtasia studio to edit the video, in fact, the same audio, insert audio, make a blank video, then you can generate video when the output format for flash, the disadvantage is not set loop playback, the advantage is that you can edit the audio itself. As shown in the following illustration:

Audio file generated Flash file, the method of inserting in Excel believe many people know, here also a brief description:

Step 1, on the Developer tab (2003 you can open the Control Toolbox directly in the toolbar), click Insert--"ActiveX control"--"other controls"--"Shockwave Flash Object" controls, insert controls in a table,

Step 2, select the inserted control, right-click--"Properties", set some properties, including "Movie": you need to give the SWF file the path and filename, "Embedmovie": set to True to embed flash, no longer need to carry files. There is a bug in the Embed feature under version 2007, loop: Set to True to indicate loops. If you need to hide the control, set the Visible property to False.

As shown in the following illustration:

When the above steps are complete, click "Exit design Mode", and you will be able to hear the music once you have saved the document and reopened it. If necessary, you can adjust the size of the control in design mode to a small, undetected, or even reduced to invisible.