I have a code that pulls the attachments out of an outlook email account and saves them to a folder structure I specified. In order to not overwrite the file each time, I added a date/time indicator at the end of the file name. I am now trying to look into each file in that folder and see if its empty, if so it will delete the file. I figured it would be easier to do this before the date/time was added since at that point each file name would be different.
It tells me “The sheet does not exist” but I have the right sheet name in the code. What is the correct way of doing this process?