macro code to save file to new folder with values and not formulas

**gokzee** · 02-01-2013, 05:19 AM

Hello!!,,

i am using the below macro to save the excel file to a new folder.but this is copying the formulas and not the values

Please Login or Register  to view this content.

how can i amend it to save the values from the sheets instead of formulas.

PLease Help

Many thanks

Gokz

**patel45** · 02-01-2013, 06:41 AM

Please Login or Register  to view this content.

**gokzee** · 02-03-2013, 10:51 PM

@patel

Many Thanks

Re: macro code to save file to new folder with values and not formulas