Save Entire Workbook as Values

  • Thread starter Thread starter ddmmyyyy
  • Start date Start date
D

ddmmyyyy

Hi - I've a spreadsheet with lots of formulas which pull in data by dat
- therefore the data changes everyday...

Just wondering if anyone knows a way I can save the entire workbook a
values in order to maintain a record of all the data...?

Many Thanks
 
Hi ddmmyyyy

You can try this to save a values copy of the worksheets in the workbook in C:\

Sub test()
Worksheets.Copy
Worksheets.Select
Cells.Copy
Cells.PasteSpecial xlPasteValues
Cells(1).Select
Worksheets(1).Select
Application.CutCopyMode = False
ActiveWorkbook.SaveAs "C:\test.xls"
ActiveWorkbook.Close False
End Sub
 
Back
Top