You have to go into folder options in the control panel (Classic view is the easiest)
And set your folders, even hiddens ones, to be visible.
Then go to "C:\<Your name on the computer>\AppData\Local\Ironclad games\Sins of a solar empire\Mods
The part of the path in bold will not be visible until you modify your folder options.
