Share via

DefaultWebOptions.LocationOfComponents Property

  • Article
Excel Developer Reference

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.

Syntax

expression.LocationOfComponents

expression   A variable that represents a DefaultWebOptions object.

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 license.

Example

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

Visual Basic for Applications 
  Application.DefaultWebOptions.DownloadComponents = True
Application.DefaultWebOptions.LocationOfComponents = _
    Application.Path & Application.PathSeparator & "foo"

See Also