Excel Can't Find File That Exists In Location

[visualnotsobasic]

Hi folks,

Hopefully a quick (knock on wood) fix.

I have a loop which is supposed to run through all files in a folder and then perform the specified code on each file.

When I run the loop, it immediately tells me that it can't find a file in the defined location, and yet I can see the exact file it is trying to open in the exact location defined.

Any ideas?

Thanks!

[ptmuldoon]

Will help if we could see the code.

If your looping all files in a folder, why is the code looking for a specific file name?

[visualnotsobasic]

For the pertinent part

Please Login or Register  to view this content.

[ptmuldoon]

Edit.

Can you confirm via debug print or msgbox the variable myfiles in showing the correct file and path? Is there spacing in the folder path names causing an issue?

[visualnotsobasic]

Does myfiles=dir not get the next file name?

I have 2 lines saving and closing the workbook prior that; the workbook in question is also not the first workbook in the folder.

I have read through the post and I'm failing to see what I'm missing; would you mind clarifying a little more?

Thanks

[visualnotsobasic]

Thanks for this. I did run a messagebox and it comes up with the filename in question. Right after the messagebox, it gives me an error box asking if the file has been moved or changed.

[CK76]

Please Login or Register  to view this content.

Do you have "\" at end of "*address of my files*" in your actual code?

My guess is that path string is slightly off.

[visualnotsobasic]

I'm actually so daft. I had forgotten a forward slash on the open command.

[visualnotsobasic]

It works now, but after a few files I get an overflow error and I honestly don't know what I'm doing wrong

Would I be best to open up a new thread with a new title and paste all the code?

[CK76]

Yes, that'd be best. Please mark this thread as solved if your initial question is resolved.