Create New Folders -help... 1

[CptCrusty1]

Can anyone point me to some generic instructions on how to create folders?

Much Appreciated..

Thanks
Crusty

I live to work and I work to live.

 

[rjoubert]

Use the mkdir function...

http://www.techonthenet.com/access/functions/file/mkdir.php

Good Luck!

 

[PHV]

some generic instructions on how to create folders
In a standard code module create the following procedure:

Sub myMkDir(strFolderName As String)
On Error Resume Next
Dim a, t As String, i As Integer
a = Split(strFolderName, "\")
t = a(0)
For i = 1 To UBound(a)
  t = t & "\" & a(i)
  MkDir t
Next
End Sub

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[CptCrusty1]

Thanks rjoubert! Thats exactly what I needed. I even added some spiffy stuff to have the folder name alwasy be the date. I"ll give you a star...

I live to work and I work to live.