I was wondering if there was some environment variable i could call from the vba code to obtain the users desktop path since they'll be different because of the Windows version and user profile.
i'm trying to copy a file to their desktop automatically but need to dynamically pull the desktop path from the code. any help would be greatly appreciated.
i'm trying to copy a file to their desktop automatically but need to dynamically pull the desktop path from the code. any help would be greatly appreciated.