How to create a new output folder

[froag]

This is for saving customer info into a unique folder based on their customer number.
I need to create a new folder based on a (record) number.
Then I can output to that specific folder.

I can tweak the VB some.

Anyone??

 

[thornmastr]

The following sub will create, if necessary, a folder for you and will put you in the folder. I am assuming you already know what you are going to put in the folder and how to do it.


Public Sub sBuildFolder(PathName As String)

If Len(Dir(PathName, vbDirectory)) = 0 Then
MkDir PathName
End If
ChDir PathName



End Sub
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com

 

[K3ith]

Hope this helps, what it does it makes a directory and gives it a name obtained from a field within a form, so I gather in your case if you have a form with a text box displaying a customer by placing the code below behind a button it would create a directory and give it the name of the current customer.

MkDir "C:\test\" & Me![customer].value