Hello Excel Guru,

I have an excel sheet that points to another excel sheet, this is because a
user always has an excel sheet open day in day out and I'm trying to create a
crystal report which doesn't like open excel sheets, so my solution was to
create an excel sheet and point all the relevant data through to my excel
sheet.

I am now stuck, I want to be able to run a script over night every night to
automatically refresh data from the excel sheet created by me and update all
the information from the users excel sheet?

Please help!!

Much appreciated.