Hi, i m serious freelancer with 100% completion rate and i can try to help you. If you had Windows PC computer, this indeed would be easy, but MAC has different code for different versions of Excel. So tell me what version of Excel are you using, and we can try to create simple example to see if folders can be created. If everything goes well i can create this script under an hour, nothing to worry. Anyway, if you are interested send me a sample file, for example path to your desktop in cell A1, and i will write you a macro that creates folder on your desktop, so you can try it. As i said i m serious freelancer and i've never took a single dollar unless my solution was perfect.
Thanks, Milan