DefaultWebOptions.LocationOfComponents property (Excel)

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 webpage if the DownloadComponents property 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.

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.