Write text file with GENERIC path...
I currently write to a temp file on my desktop. How would I re-write the path to NOT require an exact path, but be able to write to the desktop on any windows computer?
Any suggestions greatly appreciated.
Which programming language are you using?
Within Excel XHR VBA...
Here it is - https://bin.codingislove.com/ticenabafi.vbs
This post is deleted!
Thank you. Modified to create TMP folder on the desktop without knowing the path. Posting here for others, should the need arise.
Dim newTmp As String newTmp = CreateObject("WScript.Shell").SpecialFolders("Desktop") Debug.Print newTmp If Not CreateObject("Scripting.FileSystemObject").FolderExists(newTmp & "\tmp") Then CreateObject("Scripting.FileSystemObject").CreateFolder (newTmp & "\tmp") End If