ignoring an instruction on a macro loop if folder already exists

[Macro_]

Hi all, I have this coding in my macro <!-- BEGIN TEMPLATE: bbcode_code -->

<code>If blCreateFolder Then MkDir sSaveAsPath End If</code></pre>
<!-- END TEMPLATE: bbcode_code --> When I select true on my master list the code encounters an error the second time it runs as there is already a folder created. How do I make it ignore the instruction if a folder already exists?

Appreciate any help in advance!

 

[bobsan42]

First check if the folder exists. Below is a sample code:

Public Function FolderExists(foldername As String) As Boolean
'   Returns TRUE if the file exists
    If foldername = "" Then
        FolderExists = False
        Exit Function
    End If
    If Dir(foldername, vbDirectory) <> "" Then FolderExists = True _
        Else FolderExists = False
End Function