'While' function inside of error handler giving an error/failing

Hi All,

I have the following code extract, its opening a workbook however if it does not exist i want it to then find and open the latest file however its not working and just saying that it cant open the file with today's date?

Can someone please tell me where i am going wrong?

Please Login or Register  to view this content.

It's working for me, as long as I have a correctly named document in the location specified.

When I set the path to C:\Temp\ and run the code it gives run-time error '1004' because it can't find C:\Temp\qryDAConsumption 221015.xlsx and when I place a file with that name in C:\Temp it successfully opens the file. Is there any change that your file name is not exactly the same as the code is setting it? Maybe an extra space in it, or something like that?

Hi Larena,

Thanks for looking into this, yes it will work with the current days date but if the file with the current days date is not present it is supposed to search back day by day until it finds the latest file.

In this case the file i do have available is "qryDAConsumption 201015.xlsx" but its not doing the search part. Its just throwing an run-time error saying it cannot find "I:\Transaction Reports\Supply Outlook Inputs\qryDAConsumption 221015.xlsx".

Hi again,
It seems that you can't handle an error within an error (I'd never thought to try), so you need to pull all of the code out of the error. After changing it as below it is going back through previous days if the file isn't found. The paste is failing, but I haven't looked into that because I assume it's to do with the dummy empty files I'm using to test with.

Please Login or Register  to view this content.