Auto closing a specific workbook

I have open a master workbook. I am using Application.GetOpenFilename to allow the user to select and open another workbook from which data is extracted via vba. Once this is done I want this file to be closed - I think I need the filename, rather than filepath to achieve this.

I have tried using MyName = ThisWorkbook.Name once the book has been opened, but it always seem to return the name for the masterbook. Is there a way to extract the filename from the opened filepath, or otherwise close it?

It will not necessarily be the active book either.

Thanks

Store a reference to the workbook when you open it:

Please Login or Register  to view this content.

for example.

FYI, the issue with your code is you want Activeworkbook rather than ThisWorkbook - the latter refers to the workbook containing the code.