Script to refresh data and save and close

[Neil Holden]

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.

 

[David]

Is it them or you who have the most up to date file?- if them-Try turning on
their Auto save
Then have a simple macro to open their file in read only and save as a a
name of your choosing then you will get all their info even if their file
remains open

 

[Neil Holden]

It is them who has the most up to date file, I have turned the auto save on.

But.. I only want to put through certain information from his up to date
excel to mine, so i don't think a macro would do it.

Thanks anyway.

 

[David]

The macro is just to be able to have your report source a closed version of
their file not to extract information
HTH