How to make RTD dll run with manifest?

Question

I have a RTD Server (it's a dll) that I want to deploy without using the regstry or DCOM - RTD is a real-time data interface for getting data into Excel in real-time. After some research and testing, the best way seems to be to use a manifest. I've created a manifest using GenMan32, but it still doesn't work. I've embedded the manifest using GenMan32, but it still doesn't work. I'm seriously lost and need urgent help.

Do I have to put the files in the WinSxS folder?
Do I have to add some admin rights in the manifest?
What the hell am I doing wrong?

Happy to share code if anyone wants it.