Repeated Opening with VBA calls causing Excel files to open slowly

I have written VBA code into one Excel Workbook to open a different Workbook, read data and then close the data Workbook. The problem I am having is that after running one or more times the data workbook takes a very long time (60+ seconds) to open. It is slow to open both programatically and by double clicking the file.

If I make a copy of the file. The copy opens wery quickly (2-3 seconds). However after running the VBA code one or two more times the problem reappears.

I think I am opeining and closing the file properly, but it seems like the file is not fully being released. The messageboxes are showing me that it is the open action that is causing the delay. Code is below.

Please Login or Register  to view this content.

Has anyone seen anything like this?

Thanks,

Andy