Hi

I am going to use scheduled tasks to open a file at the end of each day. I then want it to run a macro to refresh the data it contains.

I can get the file to open at the scheduled time, but how do I get the macro to run on file open?

Many thanks

Tom