Сохраните набранные программы, перейдите в таблицу Excel и нажмите кнопку запуска формы. Нажмите кнопку выбора файла и укажите WAV-файл. В поле ввода формы появится его полное имя. Теперь нажмите кнопку проигрывания звука и в полной мере насладитесь работой своего творения.

Чтобы достичь более полного контроля над проигрыванием звука, например, воспроизводить звук в интервалах от 2-й секунды до 4,52 секунды, произвольно останавливать проигрывание, делать паузы и продолжать воспроизведение, и т.д., надо пойти другим путём. Необходимо запрограммировать работу приложения с мультимедиа через MCI (Media Control Interface), что мы далее и будем делать.

В следующей статье рассмотрим пример объекта для проигрывания AVI-видеороликов в окне формы через MCI. При этом вывод видео в окне выполняется независимо от основного приложения, т.е. приложение продолжает работу, не ожидая окончания видеоролика.

Пример таблицы Excel с описанными программами на VBA Вы сможете найти на http://brestmedia.f2s.com/ в разделе » Скачать «.

to be continued…

Компьютерная газета. Статья была опубликована в номере 03 за 2002 год в рубрике программирование :: разное

Using the Windows Media Player Control with Visual Basic

This section describes how to use the Windows Media Player 9 Series or later ActiveX control in applications created with Microsoft Visual Basic 6.0.

Getting Started

To add the Windows Media Player control to the toolbox, first select Components from the Project menu. In the Components dialog box, select the check box next to «Windows Media Player». At the bottom of the dialog box, confirm that the selected file is wmp.dll. After closing the dialog box, you can place an instance of the Windows Media Player control on your form in the usual ways.

You can set many control properties using the Properties window. To set some properties you must use the Windows Media Player Properties dialog box, which you open using the «(Custom)» item in the Properties window.

Object References

You use certain Player control properties to get references to particular objects. For example, the cdromCollection property returns a reference to a CdromCollection object. You must assign such a reference to a variable that you declared as the corresponding interface. In the case of the cdromCollection property, for example, you assign its return value to a variable of type IWMPCdromCollection.

Read the Interfaces topic in the Object Model Reference for C++ to identify which objects implement multiple interfaces. In those cases, you must declare an object variable as the highest-numbered interface documented in this SDK to have access to all of the properties and methods of that object. For example, you should assign the value of the Windows Media Player control currentMedia property to a variable declared as IWMPMedia3 to assure that you have access to the getAttributeCountByType and getItemInfoByType methods.

The WindowsMediaPlayer object implements all of the properties and methods of the IWMPCore, IWMPCore2, IWMPCore3, IWMPPlayer, IWMPPlayer2, IWMPPlayer3, and IWMPPlayer4 interfaces. You do not need to declare separate variables for any of these interfaces. You can access all of their members using the name you assigned to your WindowsMediaPlayer instance.

In the Visual Basic Object Browser you will see many interfaces that are intended for private use by the Windows Media Player control, including some that support skin developers. You should use only the objects, properties, methods, and events that are documented in this SDK.

Additional Tips

The reference documentation shows JScript syntax. In JScript, arguments passed to methods are always enclosed in parentheses. In Visual Basic 6.0, arguments passed to methods that do not return a value must not be enclosed in parentheses.

Some properties or methods may not appear in the Auto List code-completion feature in the Visual Basic code editor. You can still use those members by typing their names exactly as they appear in this documentation.

Manage the visual appearance of the control using the uimode property. You can do so in two ways. You can use the Select a mode drop-down list in the Windows Media Player Properties dialog box, or you can type the correct value in the Properties window.

In particular, do not use the visible property to hide the control; instead, assign the value «invisible» to the uimode property.

Using the Windows Media Player Control with Microsoft Office

This section describes how to embed the Windows Media Player 9 Series or later ActiveX control in various documents created using Microsoft Office XP.

In Microsoft Word, Excel, and PowerPointВ®, you embed the control by selecting Object from the Insert menu, then choosing Windows Media Player from the list of available object types. The Windows Media Player control appears in the document at the current location. You can then select Format Control ( Format Object in Excel) from the shortcut menu for the control to adjust the layout, text wrapping style, and other format options. In Word and Excel, you must be in design mode to do this.

Once you have positioned and formatted the control, you can configure it using the Properties dialog box, which is accessible from the Control Toolbox or from the shortcut menu in design mode for Word and Excel. Here you can specify basic Player control properties such as the control name, the URL of a digital media file, and the user interface mode. Setting the uiMode property to «none» hides everything in the control except the video or visualization window, allowing you to add your own buttons and write script code using Visual Basic for Applications (VBA) to handle the button clicks and Player control events.

From the basic Properties dialog box, you can also access the more sophisticated Windows Media Player Control Properties dialog box by double-clicking the «(Custom)» row or by clicking the ellipsis («. «) button after selecting that row. From this dialog box, you can modify all available Player control properties.

You must be careful not to take actions in Player control event handlers that will result in the control being destroyed. For example, if you embed the Windows Media Player control on a slide in a PowerPoint presentation, do not call the PowerPoint Next method from the Player openStateChange event or any other event.

In addition, you should not set the Player.URL property from a Player control event handler.

In FrontPage, add the Windows Media Player control to a webpage by selecting Web Component from the Insert menu. In the Insert Web Component dialog box, select Advanced Controls from the Component type list, then select ActiveX Control from the list of control choices. In the next window of the dialog box, select Windows Media Player. If it is not listed, click Customize and select the Windows Media Player check box in the Control list.

After the Windows Media Player control is embedded, you can position and resize it, and modify its properties by selecting ActiveX Control Properties from the shortcut menu for the control. In the HTML view, the property values that you specify appear in the OBJECT element representing the Windows Media Player control. The object name appears as the ID attribute, and the control properties appear as PARAM tags. The object name gives you access to the Windows Media Player control object model, which you can program using Microsoft JScript. For more information, see Using the Windows Media Player Control in a Web Page.