K
kay
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!
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!