Paste without source file name

[Bob789]

In Excel 2019 how do you paste all content copied from one sheet in a source file to a sheet in a new file without the the source file name showing up in the pasted formulas

[p45cal]

Do you want the formulas at all?; will plain values do?

[Bob789]

Need the formulas

[EirikDaude]

Would


Workbooks("Destination").Worksheets("Destination").Range("Whatever").Formula = Workbooks("Source").Worksheets("Source").Range("Whatever").Formula

do the trick for you?

Or are you looking for a way to do it without VBA?

[Bob789]

Preferably without vba. Just copy past