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