Hello,

When I try to save an excel file using VBA and the folder
name mentioned in the filepath is not available, then
excel gives a error message..is there any way to force
excel to crate the folder and the save the file
accordingly..

I use FilesystemObject to create folders now...but just
wanted to know if there is any other way of doing the
same!!

Thanks,
Sri