copy all sheets to a new workbook
At the beginning of the macro, put
Dim AWS as worksheet
Set AWS = Activesheet
At the end, put
Activeworkbook.SaveAs "your new values-only workbook filename here"
AWS.close false
(note untested code)
This will set a reference to the original workbook, save the new file
to a new name, then close the original workbook so you can reuse.
HTH,
JP
On Nov 15, 8:28 pm, futbol wrote:
it does work, obviously including code to finish the job saving the
workbook with values or creating another one would be nice- Hide quoted text -
- Show quoted text -
|