How do I go about passing a custom class object from Excel to Word?

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!

Hi Jeff,

I work for a construction company so my custom class is a breakdown of all of a Granny Flat's inclusions. For example, I would start with

 Dim gf as GRANNYFLAT
Set gf = new GRANNYFLAT

and then it's properties are sorted into major components, smaller components of those major components, then each property has a Value (essentially a quantity), a Cost, a Description and a Unit of Measurement (all strings and integers). Essentially, I would be using the quantity, description and sometimes the cost of each property in the word document to complete my quote.

At the moment, all I have in Word are text form fields that I would be inputting this data into.

Now that you mention it, I can't believe I didn't think to instantiate Word in excel and just do it through excel, so I will try that! However, just for my knowledge and curiosity I guess, is there a way I can pass a custom object between Microsoft Applications?