xlWorkbook.Close(SaveChanges:=False)          does not work, file name too long?

As the title suggest, the code ExcelWorkbook.Close(SaveChanges:=False) is not working.

I've never had any problems with this code before. But recently I have come across some file names which are very long (about 130 characters including white space). I checked a few times to see whether the code worked if I shortened the name, and it did. So, it appears that a large file name is causing this code to fail.

So, the question is... why is that happening, and how do I get around it (considering I don't want to simply change the file name or things like this)

Any ideas?

Thanks, AidenStart Free Trial