how to check if folder exists

[funkymonkUK]

hi does anybody know how i am find out if the folder already exist I have a macro which opens a specific folder and then creates a new folder within. It works how ever everytime I run and if the folder exists it comes up with an error Run-time error 75 : Path/file access error. which is correct as it cannot create two folders exactly the same.

any ideas around this?

[Jezebel]

trap the error.



"funkymonkUK" <[email protected]>
wrote in message
news:[email protected]...
>
> hi does anybody know how i am find out if the folder already exist I
> have a macro which opens a specific folder and then creates a new
> folder within. It works how ever everytime I run and if the folder
> exists it comes up with an error Run-time error 75 : Path/file access
> error. which is correct as it cannot create two folders exactly the
> same.
>
> any ideas around this?
>
>
> --
> funkymonkUK
> ------------------------------------------------------------------------
> funkymonkUK's Profile:
> http://www.excelforum.com/member.php...o&userid=18135
> View this thread: http://www.excelforum.com/showthread...hreadid=475775
>

[Tom Ogilvy]

On error resume next
mkdir "C:\ABC"
mkdir "C:\ABC\EFG"
On Error goto 0

--
Regards,
Tom Ogilvy

"funkymonkUK" <[email protected]>
wrote in message
news:[email protected]...
>
> hi does anybody know how i am find out if the folder already exist I
> have a macro which opens a specific folder and then creates a new
> folder within. It works how ever everytime I run and if the folder
> exists it comes up with an error Run-time error 75 : Path/file access
> error. which is correct as it cannot create two folders exactly the
> same.
>
> any ideas around this?
>
>
> --
> funkymonkUK
> ------------------------------------------------------------------------
> funkymonkUK's Profile:
http://www.excelforum.com/member.php...o&userid=18135
> View this thread: http://www.excelforum.com/showthread...hreadid=475775
>

[funkymonkUK]

thanks that workes. thanks again