Hi

I have created some charts based on data on Excel file.
Now i have stored that file (file name - latest 2008) in a folder called -
resource project.
which has data upto 09 2008 (September 2008)
so my chart is based on that.
Now in few days i will have data from October 2008.

So I want to create a macro, which will run when you open a file and pulls
current data from the file called - "latest 2008" and update charts
accordingly.

I appreciate any help to create macro.

Thanks!