Save As with formulas

[Jackie]

Hi Group,
I have 2 Excel files. One has a macro that reads through values in the
sheet and updates a formatted Template with these values. The 'formatted'
template has formulas.

This template is read-only - I have to subsequently issue a 'Save As'
command in my macro to save the updated Template. However I do not want to
save the formulas only the VALUES and the formatting.

Is this possible?

I've tried Copy and Paste but when I save the spreadsheet, all the values
are zeroised.
I've also tried Copy and Paste Special - using Values as the option, but I
lose all of the formatting.
Is there a way to save the Template without the formulas?

TIA
Jackie

 

[Danny]

I don't know why you lose your formatting when you use
paste special. I have a similar situation and I don't lose
my formatting. What I do is when I save the file as save
as on a macro, I add additional commands to copy, paste
special, values and it works. Good luck.