Can someone please tell me how can I check if a
directory/folder already exist using VBA within Excel ?

I tried the followings and it did not work

if Len(Dir("c:\mypath\myfolder")) = 0 then
mkdir("c:\mypath\myfolder\newfolder")
else
msgbox "Folder 'myfolder' already exist."

endif

Regards