On Nov 15, 1:39 pm, JP wrote:
There's some code on this page that can assist you.
http://www.rondebruin.nl/values.htm
You can use the code in "Change all the cells in all worksheets to
values", save the file with a new name, and close the original
workbook without saving. This should do what you want.
HTH,
JP
On Nov 15, 12:16 pm, futbol wrote:
hello gurus,
i'm looking for vba code to copy only values and formats to a new
workbook preserving the name on each tab.
thanks in advance- Hide quoted text -
- Show quoted text -
it does work, obviously including code to finish the job saving the
workbook with values or creating another one would be nice