Thread
:
Creating a directory from a date
View Single Post
#
1
Posted to microsoft.public.excel.programming
mark
external usenet poster
Posts: 7
Creating a directory from a date
Here's one way:
Sub test()
Dim stYear As String
Dim stExists As String
stYear = Year(Range("b10").Value)
stExists = Dir("f:\" & stYear, vbDirectory)
If stExists = "" Then
MkDir "f:\" & stYear
End If
End Sub
Reply With Quote
mark
View Public Profile
Find all posts by mark