Running a macro on file open

[emea training 2]

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

[Carim]

Hi,

You can use the following event macro
Private Sub Workbook_Open()
to be stored in ThisWorkbook module ...