Trouble using ~/Desktop to specify location of output file
If I specify the output file of Export Records as "filemac:/John's HD 1/Users/John/Desktop/Untitled.xlsx", the file Untitled.xlsx is created on my desktop.
However, if I specify "filemac:~/Desktop/Untitled.xlsx" as the output file I receive the following error message:
“Untitled.xlsx” could not be created on
this disk. Use a different name, make
more room on the disk, unlock it or use a
I would like to be able to use a script on several different computers and have the output file placed on the desktop of the user running the script, regardless of what computer is being used, so I need to be able to specify the output file without explicity referring to the volume and user. How can I do that?