Hi,

Hoping someone can help me with a challenge I'm facing. I am trying to write VBA code that includes the contents of cell D13 into a path. If you look at the code below, i'm trying to insert the contents D13 where it says "?????" (please also note that D17 is actually going to be the name of the .xls file)

So if D13 = bfg3212, it will save the file using the path C:\Documents and Settings\bfg3212\My Documents\

Thank you in advance!

sSaveName = Wks.Cells(17, "D")
With ActiveWorkbook
        .SaveAs Filename:="C:\Documents and Settings\?????\My Documents\" & sSaveName
End With