Workbooks.Open method!

Hi there,

here is a small context:
I created a worksheet for project manager to fill bi-weekly with their project's status. One worksheet per project. So each project manager have 1 excel file with many worksheets since they all have more than one project. Each worksheet as a unique name (project's id).

I created a workbook for the project management office (PMO). In that workbook, I have different worksheets and one of them lists all projects with some of their info. For that worksheet to work, I need to have a copy of all the worksheets.

I created a VBA macro that will open all excel file in the same folder and loop through all worksheet and copy them into the PMO workbook.

It was working well until recently and I just can't find why it stopped working.

Basically, the VBA macro loops through all excel files in the current folder. Open them one by one and loops through all worksheet except the one titled "Listes" and copy them into the main workbook. Pretty straight forward.

The thing is that now, when I try to open a workbook using Workbooks.Open(path_to_the_workbook), it opens it, make it active and that's it. It never reaches the next line of code in my VBA.

Any idea what's happening?

Here is the code:

Please Login or Register  to view this content.