Modules are just bags of code, intended to be shared between more than one worksheet or object. You can't explicitly place modules into the Objects folder; code that lives there is actually contained ...
If you're still writing custom PowerShell scripts for basic file transfers and Excel reports, you're working too hard. Ready-made PowerShell modules handle most common tasks better than anything ...