I am able to use Application.FollowHyperlink to open files on the network drive but I wan't it to be read only. For example, if they open a Word Document I don't want them to edit anything and save the file. I can't make folder permissions for read/write access because the users need to be able to upload files.
To sum it up; the users need to upload files and then only be able to view those files after upload. Is this possible?
Here is the "File Upload" code (it's a filecopy)
Dim FileName As String
Dim FileLocation As String
Dim UploadLocation As String
'Retrieve the file's information
FileName = Me.tbFileName
FileLocation = Me.tbFile
UploadLocation = [Forms]![frmCreateReport]![subfrmPlanAudit].[Form]![FileLocation] + "\" + FileName
'Copy the file into the audit's directory
Set oFileSys = CreateObject("Scripting.FileSystemObject")
FileCopy FileLocation, UploadLocation
Here's a quick snippet to open the file
strDocName = "C:\Documents and Settings\phamt\My Documents\Checklist.doc"