Excel 2000 VBA can I use Mkdir with variables?

The MkDir line should be

Please Login or Register  to view this content.

Fluff,
Thanks for the response!!
The directory represented by cyear already exists, I am trying to create a sub folder within that folder. I had hopped to make this so it didn't need to be modified every January.
What I need is to always create a new sub folder in the one named for the current year and then save my file there
Thanks much!
Bill

In that case you need to give Filename a value before trying to create the new folder.
I would also recommend against using VBA keywords (such as Path & Filename) for names of variables.

Fluff,
Once again you have led me into the light! I was just trying to prove out the technique but I changed all the variables to be unique names and rearranged the commands. It now works as I had wanted it to.
Current state of the macro is as follows;
[CODE]
[Sub New_Folder()

Dim cyear As Integer

Dim cpath As String

Dim cfile As String

cyear = Year(Now())
cfile = Range("D10")

MkDir "S:\Estimates & Prelim\" & cyear & "\" & cfile 'This should create the new folder

cpath = "S:\Estimates & Prelim\" & cyear & "\" & cfile & "\" 'this adds the newly created path to the save as argument



ActiveWorkbook.SaveAs filename:=cpath & cfile & ".xls"

End Sub/CODE]
Thanks again for your help,
Bill

You're welcome & thanks for the feedback