Missing .tmp File when copying a sheet

[Lucilla]

Hi All,

I need your expert support since I am stacked and I cannot find any solution.
I develop a VBA macro that works on my computer (MS Excel 2016), but when it runs on another pc it cannot work.
The errors we got are "Impossible to find the file... VB....tmp" and an error run-tim 1004 with error in the copy method in the Worksheet class.
I am just trying to copy a sheet that is present into the workbook after the first sheet:

Sub InputData()
    Check = True
    Call DefineAllVar 'Procedure in A_VariableDeclaration
    Template = Templ & Piano
    Sheets(Template).Select
    Sheets(Template).Copy After:=Sheets(HM)
    NameTemp = ActiveSheet.Name
    Sheets(NameTemp).Name = NameInput
    Sheets(NameInput).Select
...

The Sub DefineAllVar is another sub that defines Public variables, such as Templ and Piano. HM is a public const with the Home sheet name...

I really don't know where the problem is!
Thanks for any support!