Closing opened files (also non-xlsx) with VBA

[spaghetti]

Hello

I use the IsFileOpen function from VBA Express : Excel - Check If a File Is Already Open to detect if a certain file (pdf or xlsx) is open. How can I close a pdf or xlsx file that is currently opened?

What I want to achieve:

for each objFile In objFolder.Files
If isFileOpen(objFile.path) then
'close objFile...
objFile.Delete
End If
Next

Thanks

 

[spaghetti]

I know how to close workbooks, but I would like to close non xlsx files. I didn't find anything on the internet.