I have a program that uses the SaveAs feature. However, the program is going
to be used my many users and I wanted to automate the process and have the
sheet save to the desktop. My problem is that the user id which is apart of
the address changes for each person. Is there a way to just save the file to
the desktop and not worry about the rest of the address? Here is my code....

ans = MsgBox("Save file as " & sFilename)
If ans = vbOK Then
ActiveWorkbook.SaveAs "C:\Documents and Settings\????????\Desktop" &
sFilename '
End If


Thanks,
Kyle