ignoring an instruction on a macro loop if folder already exists

Hi all, I have this coding in my macro

If blCreateFolder Then
        MkDir sSaveAsPath
    End If

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!

Hi,

Try the following (untested):

'If directory does NOT EXIST, CREATE the directory
If blCreateFolder Then
  If Len(Dir(sSaveAsPath, vbDirectory)) = 0 Then
        MkDir sSaveAsPath
  End If
End If

Lewis

When I run the code with that coding I have an error that comes up in this line -

Workbooks.Open Filename:=sFullname, UpdateLinks:=0

Any ideas as to why this may be happening?
Regards,
macro_

Hi Macro_,

We need more specific information to be able to help you. If you could upload a sample workbook that demonstrates your problem, we would be able to diagnose your problem. Also it would be helpful, if you told us what the specific error was (e.g. runtime error 1004, etc.).

To upload a file, click on 'Go Advanced', underneath the reply window. Then click on the 'PaperClip Icon' above, or the 'Manage Attachments' CommandButton below the message window.

Lewis