Sorry - still don't get it. I made a map and a scenario. Then what? Tried moving the scenario file (it's a .Civ5Map file, right?) to c:\Users\...\Documents\My Games\Sid Meier's Civilization 5\MODS. It doesn't show when I start Civ and go to mods.
sounds like you only made a map if you only have a .civ5map file.
In that case you would only want to put it in the Maps folder, not the mods folder.
However, if you want to share your map on the mod hub, you will basically have to package it up as a mod, and build it, it will automatically place the correct files in the MODS folder if you do that successfully. you will still have to do other things, but it sounds like you haven't read the tutorial, so I'll stop here. Try the tutorials and reference section.