Generic Desktop-path
Code:
    With CreateObject("WScript.Shell")
        SpecialFolderPath = .SpecialFolders("Desktop")
    End With
If you make only 1 file each day, you could add a date to the filename so it's unique name every day.