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...
Any help would be appreciated, thank you!Please Login or Register to view this content.
Bookmarks