LocationOfComponents Property
You can use the LocationOfComponents property to specify or determine the central URL or path where Microsoft Office controls can be downloaded by authorized users viewing your saved database. Read/write String.
expression.LocationOfComponents
expression Required. An expression that returns one of the objects in the Applies To list.
Remarks
The LocationOfComponents property is available only by using Visual Basic .
The Microsoft Office controls are automatically downloaded with the Web page if the DownloadComponents property is 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 where Office components are downloaded.
Application.DefaultWebOptions.LocationOfComponents = _
"\\Server1\CompLoc"