Hey all,

I have an excel sheet that I use to put together costings, and to do this I put all of the variable costs into a UserForm and with the help of a custom class object I created, it is distributed into the relevant cells.

After I have finished in excel, I want to pass my object to Microsoft Word so I can easily transfer the data in one variable. I cannot seem to find any guides online or any help anywhere that tells me how to do this. I have tried multiple avenues, but the closest I have gotten is to create a variable that represents the excel sheet, and that's about it.

Can anyone offer any advice on how I can pass custom objects between Microsoft Applications?

Thanks in advance!