I have a workbook that I use to generate data from various sources into a reportable format. I now want to find a way using vba to:

- select certain sheets within the book
- save these sheets as a new file to a selected folder with only the values (no formulae)

Any ideas?