With both computers on the same network, one can access the other, but is there a way to run a macro in an excel that is currently being used by a different user, so that it updates in front of the other user?

I am trying to get this code to work but not sure what needs to be changed:

Sub Main()
Dim fileTest As String = "N:\Temp\template.xlsm"

Try
Dim F As Short = FreeFile()
FileOpen(F, fileTest, OpenMode.Binary, OpenAccess.ReadWrite, OpenShare.LockReadWrite)
FileClose(F)
Catch
Dim xl As Excel.Application = Marshal.GetActiveObject("Excel.Application")
xl.Visible = True
xl.Run("test2")
Exit Sub
End Try

Dim xl2 As New Excel.Application
Dim oTargetWb As Excel.Workbook
oTargetWb = xl2.Workbooks.Open(fileTest)
xl2.Run("test2")

oTargetWb.Save()
oTargetWb.Close()

xl2.Quit()
xl2 = Nothing
End Sub