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?
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

dandetroit

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

New Member
Joined
Jun 12, 2002
Messages
43
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,806
Messages
5,598,188
Members
414,218
Latest member
speedbit

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
Top