I am looking for a macro that will determine the last time a file was saved. In other words I a have a Workbook open and wish to have a macro run that will put the date and time that another workbook was last saved. Also the user that saved it.
In case I am the only "Expert" to notice you actually asked for "...the date and time that another workbook was last saved...", please substitute the fully-qualified (folder &) filename for "c:\folder\Filename.xls"
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.