I have a workbook with many sheets
One sheet is called "overview"
This has summary of various other sheet's info
thus it refers to other sheets' cells
I want to do following with a vba command
save overview sheet as separate workbook with one sheet only
replace functions and references in each cell with current value(and format)
(that way even though original workbook is updated over time
I'll have an archive of the overview at various dates in past)

any tips on an easy way to do that appreciated.
so far options I can think of:
1)
save original workbook so changes aren't lost
change the formulas and references on the original "overview" sheet,
file saveas new name
delete all sheets but "overview"
hopefully that will leave original workbook intact (though it will no longer
be open or active)

2)
copy "overview" sheet in original workbook to a new temp sheet
replace formulas with values in new sheet
somehow export new sheet to new workbook (i'll have to research how to do
that)
delete new sheet from existing workbook
that way I can still be in original workbook(if that's important which may
not be a big deal)

3)
i'm sure there's a better way but drawing a blank, any ideas?

something like:
Sub ExportSheetValues(SourceSheetname as String, newBookname as String)
....implementation here....
End Sub

thanks
mark