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.
expression A variable that represents a DefaultWebOptions object.
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.
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"