View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Orion Cochrane Orion Cochrane is offline
external usenet poster
 
Posts: 119
Default Making Directory if None Exists

I need help making a directory if there isn't one present. I know you have to
use the mkdir command, but I don't know how to use it.

Here's an example:

I run a file, clear its contents, and save it. If I am clearing a December
file, I want a January file in a folder named 2010 in the current directory
and go up one folder (above the 2009 folder).

Basically, I need code to check whether a 2010 folder exists in a directory
path, and, if not, create it and save the file there.

TIA.
--
I am running on Office 2003, unless otherwise stated.