I have a little job where I need to use VBA code to copy some files from a CD to a computer, then create a desktop shortcut to one of them.
What works sometimes is to create a FileSystemObject, then use it to copy a shortcut file to the desktop folder.
With windows 95 and 98 the desktop folder is c:windowsdesktop
Is there any way of detecting where the desktop is, if it is somewhere other than this?
If the computer has got user profiles established, I would like to copy to the "All users" desktop. Can I find out where that is?