i currently have a macro that saves a file to a location specified in a ceratin cell
Sub Button989_Click()

ActiveWorkbook.SaveAs Filename:=Range("C37") & Range("C36").Value & ".xls"
End Sub
I need to do couple of things.

1. get the above macro to save to desktop without having to insert the path...
2. i want to give the option of saving it on the desktop or a folder in the c drive

the problems

how do i get excel to read the comptuer username to do the save as on the desktop

ALSO how do i get excel to make a folder if the folder on the c drive does not exist

is this even possible?

Thank you