The issue is that you put it in the wrong path. Assuming it's a zipmod, which all the additonal maps I've seen have been, it goes in the mods folder off your main directory (e.g. D:\HoneySelect2\mods).
Also, because of how you phrased it, I want to be sure I answer something else. You don't pick it during a sexual encounter (choosing an HScene, meaning a sexual position). You can get there from the Meeting Room, or by leaving your room and exploring (I forget the option name, but it's a choice after Leave Room from your bedroom). When doing the deed, you are stuck in your current map until you choose to end the encounter. Hscene friendly just means that the modder has included places in the map for certain, well... activities to occur.