Solved: Sort all files in a folder and open the latest one

[arrun]

Dear snb, I have a problem with your code. Problem is coming, if in the folder name, there is some space. Say my folder is [vba]c00 = "G:\OF\Fol 1"[/vba] then I am getting following error:

Run-time error '9':
Subscript out of range

Is there some workaround?

I am using Excel-2003

Thanks