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

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

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

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 -