LocationOfComponents Property

Microsoft Excel Visual Basic

Returns or sets the central URL (on the intranet or Web) or path (local or network) to the location from which authorized users can download Microsoft Office Web components when viewing your saved document. The default value is the local or network installation path for Microsoft Office. Read/write String.

Remarks

Office Web components are automatically downloaded with the specified Web page if the DownloadComponents property is is set to True, the components are not already installed, the path is valid and points to a location that contains the necessary components, and the user has a valid Microsoft Office 2000 license.

Example

This example sets the path to the location from which users can download Microsoft Office Web components.

Application.DefaultWebOptions.DownloadComponents = True
Application.DefaultWebOptions.LocationOfComponents = _
    Application.Path & Application.PathSeparator & "foo"