View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default check and create folder for saveas

Another way is to just ignore the error if there's a folder already there.

on error resume next
mkdir "a:\myfolder"
on error goto 0

This assumes that you wouldn't have a filename that has that name.



Sunil wrote:

how do you chech if a folder exists and create one on A: drive is it is not
there ?
Please help a newbie- Thanks :-}


--

Dave Peterson