DefaultWebOptions.DownloadComponents property (Excel)

True if the necessary Microsoft Office Web components are downloaded when you view the saved document in a web browser, but only if the components are not already installed. False if the components are not downloaded. The default value is False. Read/write Boolean.

Syntax

expression.DownloadComponents

expression A variable that represents a DefaultWebOptions object.

Remarks

You can set the LocationOfComponents property to a central URL (on the intranet or web) or path (local or network) to a location from which authorized users can download components when viewing your saved document. The path must be valid and must point to a location that contains the necessary components, and the user must have a valid Microsoft Office license.

Office Web components add interactivity to documents that you save as webpages. If you view a webpage in a browser on a computer that does not have the components installed, the interactive portions of the page will be static.

Example

This example allows the Office Web components to be downloaded with the specified webpage, if they are not already installed.

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.