I have a VBA program I wrote that runs a series of queries and then pulls the data from these queries into Pivot Tables that feed into and then print a series of Tables and Charts. I run this program every 2 weeks. I now need to save the outputs, without all the programming and PT baggage, so we can access past outputs.
Question: How would I write the code that will save the tables and charts without the equations and the rest of the overhead (like save Special Values) with a date indexed filename?