You have to be very careful here because you are using SaveCopyAs. You want to make sure that you remove formulas from the copy, not your original workbook. I suggest using SaveAs instead. Here is what I would do:
However, when this code finishes, the active workbook will now be the copy, with its new name. Using SaveCopyAs leaves the original workbook as the active workbook and does not open the copy.
Edit: I assumed you have multiple worksheets but if not then you don't need the For loop. You can just copy and paste on Worksheets(1).
Bookmarks