I have a model that requires user to get data from a saved file on their desktop. The saved file is "[login to view URL]" . This will be universal for every user. It will be saved on their desktop as "Statement".
I recorded a macro to get data from MY OWN desktop and it works once i press the command button but once it gets to another PC it returns error. I need a code in the form of possibly
spath = Environ("USERPROFILE")&"DESKTOP"
Check file to see example