Ok, so I currently have a workbook (Report2011) which records data each week (in a new sheet), and then dependant upon the choices made in sheet1, constructs a summary sheet which returns the averages over the time period selected, as well as showing graphs which illustrate the trend over time for each category in the summary.
What I would now like to do, is to create an almost identical workbook, which corresponds to the following year (Report2012). However I want to add a function where by the user can select a checkbox on sheet1 (We'll call it cbx2011), and when cbx2011 is true, the 2 procedures related to building the graph (to illustrate trend over time) would also be ran in Report2011, however the results would be added to the same graph in Report2012, to enable an easy comparison between the 2 years.
So the first question I have is, how do I open a closed workbook, and then run a procedure in that workbook?
Thanks in advance for any help
What I would now like to do, is to create an almost identical workbook, which corresponds to the following year (Report2012). However I want to add a function where by the user can select a checkbox on sheet1 (We'll call it cbx2011), and when cbx2011 is true, the 2 procedures related to building the graph (to illustrate trend over time) would also be ran in Report2011, however the results would be added to the same graph in Report2012, to enable an easy comparison between the 2 years.
So the first question I have is, how do I open a closed workbook, and then run a procedure in that workbook?
Thanks in advance for any help