Excel intranet problem

[grovesy]

Hi all. this is an excel/vba/web problem let me explain.

I have an excel file with vba that allows users to generate a calenda
style workload so we can see what they are currently working on.

I now have all of this system working and the user can press a butto
that saves on the the worksheets to a new file (I have done this). Thi
file is saved on a server.

I then have a small intranet that links to this file so anyone withi
the company can see what a user is working on, the problem is this...

... If a user is "viewing" someones workload excel sheet and, at th
same time, the person who owns the worksheet updates it and then click
the button that saves the file to the server again (affectivl
overwriting the old one) this user gets an error because someone i
viewing it, therefore it is open!!!

Any ideas how I can fix this? Would making the excel file ReadOnly
work?? Can I get the webpage to open the excel "workload" fil
differently so it makes a local copy or something?

Cheers ;

 

[grovesy]

If its any help I use this code to currently save the worksheet to th
server


Code
-------------------

Sub Publish()
Dim calendarName As String
Sheet2.Copy
calendarName = "//server/taskview/john.xls"
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs (calendarName)
Application.DisplayAlerts = True
ActiveWorkbook.Close
End Sub

-------------------


and to view this document in the webpage i just have a link that link
directly to it


Code