Make Directory

I understand the concept of MkDir command where I use it to make a new folder in some directory such as MkDir "C:\Test\Test" and also in how to make a folder based on a textbox input such as MkDir "C:\test\" & txtRMA.text. No issues there I know that a folder in the test directory will be named whatever the value of txtRMA.text is. My question is I need to create two folders inside of that one that is INBOUND and the other is OUTBOUND. Basically looking to do this: "C:\test\((VAL)txtRMA.text)\INBOUND" and "C:\test\((VAL)txtRMA.text)\OUTBOUND" all in one step if possible. Any assistance would be greatly appreciated. Sorry no excel file or screenshots this is early in the program and do not have anything in the file yet.

This will get you started :

Please Login or Register  to view this content.

Thank you, Logit,

After reading through your suggestion I found that I was leaving out a string and used the following to do what I was needing to do.

Dim newfolder As String
Dim newfolder2 As String
Dim path As String
Dim path2 As String

If Len(Dir("c:\test\" & txtRMA.Text, vbDirectory)) = 0 Then
path = txtRMA.Text
MkDir "C:\test\" & path


path2 = "C:\test\" & path

MkDir path2 & "\Inbound"
MkDir path2 & "\Outbound"

End If

This did exactly what I needed it to do and I again appreciate the help. As you can see I did not use any part of the spreadsheet. I do plan on using that later as storage for time received repair and time depart or repair facility and other stuff like storage location and whatever else is needed. However, I know I need to have a MSGBOX that will popup after the text box is populated that asks "Inbound or Outbound" to select the desired folder but would you have any suggestions as to how I could use a webcam, or something similar that would take 3-4 pictures with the push of a button and have them saved in the selected folder from the MSGBOX?

Glad you found an answer !

New question for the make directory strings from before. My work receives repairs daily and ships repairs out daily. We have ran into some shipping issues and would like to cover ourselves with pictures both of the inbound and outbound product. Is there a way in which I can automatically have these pictures saved in their respective folders? Or at least, once the camera is connected to the computer it will open the respective folder as the 'suggested" location?

Was wondering if I could bother you for one more quick solution? I have this same program that you helped me with a few months ago and have ran into a problem. If the existing folders already exist I get a debug error. Is there a way to go from the following to compare and see if the directory already exists and skip all the MKDIR commands and have it just open the existing folders? Thanks for your help.

Dim newfolder As String
Dim newfolder2 As String
Dim path As String
Dim path2 As String

If Len(Dir("c:\test\" & txtRMA.Text, vbDirectory)) = 0 Then
path = txtRMA.Text
MkDir "C:\test\" & path


path2 = "C:\test\" & path

MkDir path2 & "\Inbound"
MkDir path2 & "\Outbound"

End If

renrut_5

Answers are pending. You must comply with the Moderator first.