Hi,
I want to use a command button to create a folder within a folder that I had already created using a field's name as the name of the folder. This is what I have so far:
Public Sub Command68_Click()
Application.FollowHyperlink Path
Application.FollowHyperlink "\\CEP-FS1\Shared\Project Tracker\" & ProjNum.Value & "-" & ProjName.Value
If Len(Dir("\\CEP-FS1\Shared\Project Tracker\ProjNum.Value & "-" & ProjName.Value\" & "Meeting Minutes", vbDirectory)) = 0 Then
MkDir ("\\CEP-FS1\Shared\Project Tracker\ProjNum.Value & "-" & ProjName.Value\" & "Meeting Minutes")
End If
End Sub
So, the first part of the code works great. It opens up the folder (\\CEP-FS1\Shared\Project Tracker\P13001-Overall Equipment Effectiveness (OEE) for Production). But the second part of the code (the IF clause) I keep getting an error saying "Type Mismatch". I don't know what I'm doing wrong. I want the path to look like this: \\CEP-FS1\Shared\Project Tracker\P13001-Overall Equipment Effectiveness (OEE) for Production\Meeting Minutes
I want to be able to create a meeting minutes folder within each project's project folder which has already been creating using a different command button.
Any help or ideas would be greatly appreciated. Thank you!