Workbooks Loop Run-time error '1004':

[trizzo]

Hello,

I am looping through workbooks, whenever file name has "CAP CPU" on its file name it opens the Workbook, using the below code:

Please Login or Register  to view this content.

Here is the error I am getting
Run-time error '1004':
Sorry, we couldn't find CAP CPU_New.xlsm. Is it possible it was moved, renamed or deleted?

I am using Windows 7, and the file is in the correct folder. By looping with F8 I can see StrFile gets the correct file name "CAP CPU_New.xlsm".
It is strange that it worked twice, now, it is not working anymore.

Can anyone help me please?

Thanks!!

[Mad-Mizer]

Perhaps the following (small change):

Please Login or Register  to view this content.

[trizzo]

Hey Mad-Mizer, thanks for quick response!! But, it is still not working.

[trizzo]

Can anyone help me, please? The issues seems to be with Application.Workbooks.Open (StrFile). Thanks!