Can you show your code?

--
__________________________________
HTH

Bob

"Neil Holden" wrote in message
...
hi. thanks for your answers, I can't make a copy of it because i need up
to
date information from it on a daily basis so i can report from Crystal.

Not sure if some application even code would work as I already have code
to
close the excel once updated but it stays open.

"Bob Phillips" wrote:

Add some application event code to close that other workbook after a
period
of inactivity perhaps.

--
__________________________________
HTH

Bob

"Neil Holden" wrote in message
...
Please help, i have an excel sheet which is full of data, I have set up
a
new
excel workbook which pulls information from the other excel sheet.

The problem i have is this user is constantly in the main excel sheet
and
I
need the data from his sheet, I have set up a scheldule to
automatically
open
my sheet during the night and close automatically, but it stays open in
the
open files and this basically doesnt work.

If you know a better way of doing this please let me know it would be
greatly appreciated.

Neil.