Debugging Array Error

I want to write code that will check in a directory (C:\Test\) if a folder exists, and if the folder does not exist then create the folder. What I tried to this point was:

Please Login or Register  to view this content.

I get a debug error of type mismatch with the ode I have above. What I am trying to do is to cycle through each of the folders in M and create a directory in my target. But there has to be something wrong with my code.

Array is the name of a VBA function; if you name a variable that, then you can't use the function.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Then your array is named M, not Array.

Please Login or Register  to view this content.

The folder C:\Test must already exist.

Wow, I wasn't even in the same ballpark. Thank you for that! One followup, would it be possible to combine a save feature to that code? Meaning the same avsFolders that were just created, are folders that I need for quick recognition of data. So for example I have a module called Folder1 that does some refresh operations, copies some data etc etc, and then I would want my module Folder1 to save in the Folder1 I just created.

As opposed to manually writing a save feature for each module, would it be possible to cycle through each of the avsFolders with code similar to this:

Please Login or Register  to view this content.

or to somehow reference the avsFolder when saving? so maybe something like:

Please Login or Register  to view this content.