Script to refresh data and save and close
 

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.

Script to refresh data and save and close
 

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
--
HTH


"Neil Holden" wrote:

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.

Script to refresh data and save and close
 

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" wrote:

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
--
HTH


"Neil Holden" wrote:

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.

Script to refresh data and save and close
 

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



"Neil Holden" wrote:

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" wrote:

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
--
HTH


"Neil Holden" wrote:

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.