Hello all,
I have an Excel document with some VBA that is creating some new Excel documents and is storing them in some folders.
The folder and file names are stored in an array and to overcome errors I check if the folder exists ( fs.folderexsists(fldrarry(n)) ), and if it isn’t then I creat the folder.
The problem I have is that if the path consists of more folders e.g. “C:/folder1/folder2/folder3” and folder2 and folder3 don’t exists it is not possible to create them at ones with the command: fs.createfolder(fldrarray(n))
How could I sove this problem easy?
Thanks in advance for your reply.
