Hi Ryan,
I wonder whether Excel will know "activedocument".
Try
doc.Variables("Broker_First_Name").Value = ...
or
objWord.activedocument.variables("Broker_First_Name")...
instead.
--
Greetings from Bavaria, Germany
Helmut Weber, MVP WordVBA
Vista Small Business, Office XP