I've been using MkDir for some time in my code to create directories. However, I have discovered the limitation of this command in that it will only create 1 directory at a time. If I want to create multiple directories at a time, the function fails to perform.
If my hard disk has folder path: C:\Test
But I want to create the following directory: C:\Test\A\Apples
In order for MkDir to work, I need to have first created the C:\Test\A directory.
I found some a code to solve the problem on this website: http://www.cpearson.com/excel/MakeDirMulti.htm
But when adding code to my application and compiling, the compiler stops on the following line of code:
ERROR = "Method or Data member not found".
I think it's because I haven't enabled the Reference for this function. If that's correct, what Reference am I missing?