Dear All,

A xls-file with the day-planning on the company-server.
ComputerA has the xls-file always open to project it on a big screen to be
seen by all.
I have to edit the xls-file on computerB in another location in the network.

IS IT POSSIBLE to refresh-screen on computerA from computerB, after I edited
the xls-file
on computerB.

Thanks,

Filip

Possibly you can look at the Shared workbook options. I don't use that
capability, so I don't know when the workbook is actually refreshed - but it
is the only thing I can think of that might support this. Both Computer A
and B would have to work on the same physical copy of the file.



--
Regards,
Tom Ogilvy


"Filips Benoit" wrote in message
...
Dear All,

A xls-file with the day-planning on the company-server.
ComputerA has the xls-file always open to project it on a big screen to be
seen by all.
I have to edit the xls-file on computerB in another location in the
network.

IS IT POSSIBLE to refresh-screen on computerA from computerB, after I
edited
the xls-file
on computerB.

Thanks,

Filip

If Tom's shared WB solution does not take care of this for you, you could
try the manual way.

When you open the file on B, it creates an instance of Excel on A. You then
have your reference to that xlApp. Using xlApp, open the file read-only, or
as a copy.
Dim xlApp As Excel.Application
' Replace string "\\MyServer" with name of the remote computer.
xlApp = CreateObject("Excel.Application", "\\MyServer")

Edit the file on B. Re-open the file A.

NickHK

"Filips Benoit" wrote in message
...
Dear All,

A xls-file with the day-planning on the company-server.
ComputerA has the xls-file always open to project it on a big screen to be
seen by all.
I have to edit the xls-file on computerB in another location in the
network.

IS IT POSSIBLE to refresh-screen on computerA from computerB, after I
edited
the xls-file
on computerB.

Thanks,

Filip