%appdata% is system variable.
It is a short hand notation for the appdata folder at:
C:\Users\<username>\AppData\
This will open the Appdata folder even if it is set to be a hidden folder. Most likely, the problem you where running into was that the AppData folder is set to bee a hidden folder.