Hi all,

I have this case
I put the excel file .xls in the server, and use some vba script to protect
the workbook and add some validation too, now when the user open this .xls,
it copy the workbook to the user local harddisk c:\program file\.....somewhere
so when the user save the xls, it only save to its harddisk, not the server
one

Any professional can tell me what should I do ?
It is a urgent case for me _<

Thanks very much

Hey man,

Consider this. If users did save back to the server (if it let them), it'd
overwrite changes made by other users who saved earlier. Have you
considered using Tools, Share workbook?
--
Earl Kiosterud
www.smokeylake.com

"man" wrote in message
...
Hi all,

I have this case
I put the excel file .xls in the server, and use some vba script to
protect
the workbook and add some validation too, now when the user open this
.xls,
it copy the workbook to the user local harddisk c:\program
file\.....somewhere
so when the user save the xls, it only save to its harddisk, not the
server
one

Any professional can tell me what should I do ?
It is a urgent case for me _<

Thanks very much