Hi, I am trying to save a file to directory. I want the saveas dialogue box
to pop up with the file name and pathe I specify, but I want the user to be
able to change the path given that it changes on a monthly basis.

With Sheets("MissingSTAvg_Corp")
.SaveAs Filename:= _
"Q:\Results\March 06\MissingSTAvg_Corp" & InputBox("Please Enter
Date As MM-DD-YY")
End With

The "March 06" will change monthly. Thanks