Saving files without formulas attacthed to figures

[Macro_]

Hi all, I have a macro which updates data sets and then save each individual data set to a designated folder. I need the macro to update the data sets, then remove the formulas attached to the figures in the sets before saving them to their specific folders... any ideas? Thanks in advance for any help

[Speshul]

You can have a macro Select All and Copy/Paste Special/Values only. Record yourself performing these steps, then put that code in the BeforeSave section of "ThisWorkbook"

Just be careful to set the macro to enable saving with formulas first

Please Login or Register  to view this content.

[Macro_]

That is exactly what I am trying to achieve. I am new to macro and am confused as to where exactly to put the copy/paste special coding. I currently have this code..

Sub Macro3()
'
' Macro3 Macro
'
'
ChDir _
"X:\filelocation"
Workbooks.Open Filename:= _
"X:\filelocation.xlsm" _
, UpdateLinks:=0
ActiveCell.Offset(-1, 0).Range("A1").Select
ActiveCell.FormulaR1C1 = "variable"
ActiveCell.Offset(1, 0).Range("A1").Select
ChDir "X:\filelocation"
ActiveWorkbook.SaveAs Filename:= _
"X:\filelocation\variable.xlsx", _
FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False

[Macro_]

Okay so found out this copy/paste special code works, almost.. the colours of highlighted cells aren't copied to the relevant cells....

ActiveCell.Offset(1, 0).Range("A1:S84").Copy
ActiveCell.Offset(1, 0).Range("A1:S84").PasteSpecial Paste:=xlPasteValues
ActiveCell.Offset(1, 0).Range("A1:S84").PasteSpecial Paste:=xlPasteFormats