How to close a file whose name is composed by a value and a variable

[AmicusA]

Hi,

With this code

Please Login or Register  to view this content.

I manage to open a file whose name depends on the value of a cell (Name) and a variable (year) & .xlsx.
At the end of the Sub I have to close it without saving it, but all my trials where unfructuous.

How has that code to look like?

Kind regards
AmicusA

[CK76]

I'd usually put workbook into variable.

Please Login or Register  to view this content.