将工作表值保存到另一个工作簿

I have a code that could save a specific worksheet where you can pick its file name and path. The problem is it also copies the formulas when the new file is saved. I need to copy only the values, because the file is too big and I don't need the formulas in the new save, just the values. I have a code that could save a specific worksh