Results 1 to 1 of 1
2001-07-24, 20:24 #1
- Join Date
- Jan 2001
- Baltimore, MD, Maryland, USA
- Thanked 0 Times in 0 Posts
Auto save Tables and Charts (EXCEL97/SR2)
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?