Workbooks.Open freezes excel...Macro-enabled and not Macro-enabled :(

Hi All,
It's my first time attempting to extract information from a second workbook as part of a module in the original workbook.

This workbook already has 2 large modules in it, and the workbook I need to pull data from will be an exact copy of the current workbook, but with the previous month's data. However, everytime I run the below code (3rd module now) excel freezes as it opens the named file, and I have to force close it all. This happens when I save previous month as macro-enabled and just a normal excel workbook.

Please Login or Register  to view this content.

This problem doesn't occur when I open much smaller random excel files, so I know the code itself is fine but maybe I should be manipulating last months file somehow to make it easier for excel to open. Any insight is greatly appreciated (and unfortunately I cannot post original files as they are full of data that would take far too long to scrub).

Thanks!

Hi JLG, thanks for your suggestion but no luck.

Are there alternative ways to try to open the workbook to see if they freeze the screen as well?