Thank you for your info about the Power Query. It's new for me. I will certainly use it in future. Correct me if I'm wrong, but power query is more if you have the data in table form like in a database. The workbooks I'm extracting data from, are very unstructured and data are to be found spread out over the whole worksheet.
set wb = nothing or wb = nothing
didn't not make any change.
It's actually the same, if I open a workbook manually - the VBproject stays in memory after I closed the workbook. I can see it in the macro window