Hi Guys,
I need to check if a folder exists and if not then create it...
not sure how to go about this![]()
Hi Guys,
I need to check if a folder exists and if not then create it...
not sure how to go about this![]()
Last edited by mattmac; 01-28-2009 at 10:17 AM.
Check the LEN of the Dir and if 0 use MkDir.
For more info there's a good guide here: http://www.techonthenet.com/excel/formulas/mkdir.php
Note importance of directory structure... ie each folder in the path must exist... you can't create a sub folder in another folder if the parent folder doesn't exist either.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
thats a nice simple guide
cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks