.FolderExists method Returns TRUE when FALSE

Incredibly annoyed but I think I know why it is happening.

All the sudden, this code has been returning TRUE for .FolderExists when its clearly FALSE. The code checks for the directory: ThisWorkbook/Quote Folder/XXXX where XXXX is a unique number.

Quote Folder is completely wiped empty and the code is saying Quote Folder / XXXX exists - There is nothing in Quote Folder

Now, I think this is happening because I have created many backups of my workbook. My workbook is on my desktop in a folder. After every night, I copy the folder and rename to "back up + date". So, i think somehow Excel is confused and it is referencing a completely different path than the current open workbook!!!

Annoying. Any ideas?


CODE:

Please Login or Register  to view this content.

Hi folks,

I remedied this by rolling back to simple code which omits the "if folder exists" logic. It appears the code is buggy but I haven't quite put my thumb on why this code is flawed and returns TRUE for if folder exists when it in fact does not.

THanks