PDFsharp & MigraDoc Foundation

Hi All,

I've recently been trying to bulk export password protected PDF's directly from Excel with the password for each PDF contained in a cell. From a lot of Googling it's evident that it is not possible within Excel and VBA alone so I've been trying to use PdfSharp in VBA which allows for this. I've had some looking around and used it within Visual Studio and it works however when trying to convert it to be used in VBA via Regasm it doesn't appear to work. I generate the tlb file and then add into VBA resources successfully but when looking into the library itself it's blank. Any idea on where I am going wrong would be fantastic.