Hyperlinking to Excel files in Read-Only mode

G

Gadget1

I have setup a dynamic hyperlink to excel files within an Access application
using the following code:

Private Sub cmd_ConstrLnk_Click()
Dim ConstLnk As String

ConstLnk = RTrim(Me!fpm_profile_code) & "\" & RTrim(Me!fpm_profile_code)
& "-" & RTrim(Me!fpm_finish_code) & ".xls"
CreateHyperlink Me!cmd_ConstrLnk, "S:\PROFILE_Construction_xls\Style" &
ConstLnk

End Sub
The above works well except that it always opens the excel file in an
editable mode. Is it possible to open in Read-Only mode by extending the
above code?
 
Top