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

dandetroit

New Member
Joined
Sep 16, 2002
Messages
15
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?
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
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
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,196,462
Messages
6,015,385
Members
441,889
Latest member
balolaptopgiaolong

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top