Program tries to create subfolder again when it already exists

[cmce]

Hi,

I am pretty new to this and am looking for help! I have a macro, in excel 2007, that will create a main folder and then create a sub folder using cell data for both folders. Then it would save the workbook in the sub folder. My problem is that when I go to run the program again, it tries to create the subfolder again, causing an error. What do I need to put in my code to correct this? Any and all help would be appreciated. Thanks in advance.

[TMS]

Use

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

around the line that creates the folder.



Regards, TMS

[cmce]

Here is the code that I am using. Not sure exactly where to put it.

Please Login or Register  to view this content.

[TMS]

I guess it's going to go inside this routine: CreateSubfolder

Regards, TMS

[cmce]

Here is the complete code:

Please Login or Register  to view this content.

I get a compile error Expected: expression when I put in On Resume Next. Did you mean On Error Resume Next?

[TMS]

Sorry, that should have been "On Error Resume Next"

[cmce]

Thanks for the help. I had to put the code in 2 locations to make this work.

Please Login or Register  to view this content.

[TMS]

You're welcome. Thanks for the rep.