How do I rename a file, keep all data, but erase formulas/li

[dandetroit]

Is there a way to save a file that has many links and macros as a file of another name that contains all of the information contained in the original file, and looks identical, but breaks all links, formulas, and macros?

 

[dandetroit]

Additional comment... Here is the code I am saving the file with. I need to do it via this code...

It would be much appreciated if anyone can add the code line to accomplish the above issue. Thanks!

Private Sub CommandButton1_Click()

Dim MyName

MyName = Range("$E$8")
FileName = "T:fsd dashboardford buford bu dashboard " & MyName
ActiveWorkbook.SaveAs (FileName)

End Sub

 

[RAN_MPA]

I will admit I've never written VBA code for Excel, so my approach may not be what you need, but it works for my purposes. It would seem to me that you should be able to write a macro (or use the Recorder) to accomplish the same results.

I simply highlight the entire worksheet, Copy, Paste Special, Values. You can also Paste Special the Formats in another step.

Hope that gets you started in the right direction.