Stop user from closing workbook until conditions apply

[Jacob Hilderbrand]

Of course we can do this.

[VBA]
Dim Desktop As Object
Dim MyPath As String

Set Desktop = CreateObject("WScript.Shell")
MyPath = Desktop.SpecialFolders("Desktop")

[/VBA]

Now you have the path. Do you need the code to save to that path?