I am having an issue with figuring out how to close a workbook. I know
how to close a workbook when the filename is constant/known but not
when it is dynamic. The scenario is that my Main macro reads in a text
file causing a temporary workbook to be created. It then copies data
from the temp wb into the main wb. Problem is i cannot close the temp
wb because its name constantly changes (book1, book2, etc. ). The
soulution i am looking for is to be able to specify the name of the
temp wb at creation, or capture its name for closing once the data has
been copied to the main wb successfully. I suspect the Freefile
variable is the cause of the temp wb changing from Book1 to Book2 and
so on. Is there a way to set the temp wb name somewhere?

Thanks,