opening file based on most recent modification date in

[Quint6778]

I am trying to open the most recently modified .CSV file from a folder, and it's seemingly working except for the .Open part. When i manually open it, there is no prompt stopping me so i dont understand. The error message i get says, run-time 1004, "*the exact file name im trying to open*" could not be found. Check the spelling and verify file location. ... So its finding the right file because it tells me in the error msg. I can also use an input box to specifiy the file to open by name, and that works. Im hoping someone has seen the issue before, or maybe its something that stands out to the professional (not me) eye...

Please Login or Register  to view this content.

Any help would be appreciated, thank you!

[AlphaFrog]

Include the file path with the file name.

Please Login or Register  to view this content.

[Quint6778]

@Alpha : i dont care how simple it was, or how dumb i feel... im always equally amazed when presented with the answers. THANK YOU VERY MUCH!