Any idea of how to close list of workbooks using VBA ?

[xlhelp15]

Hello Genius - Is there a way to close list of workbooks using VBA ? Have tried the way of Workbooks("sample1").close but it closed only the sample1 WB. I need to close Sample1, Sample5, Sample12 in a row when I click the command button.

Thank you for considering my request.

 

[Captain_Conman]

Workbooks("Sample1").Close
Workbooks("Sample5").Close
Workbooks("Sample12").Close

If you list them in a row like this, they will all close when you hit the command button

 

[xlhelp15]

Thank you, Captain.

But it works only when those sample workbooks are in open status.

It needs to close the file if it exists, otherwise no action to perform.

Any help here ?