I have a spreadsheet containing information about who has what training and when they received their training. I want to make a progam in VBA that creates training certifications based on that spreadsheet and then links each cell to its corresponding certification.

In order to create each certification, I thought I'd do a find/replace in Word on a template, saveas, and repeat, but apparently doing a find/replace in Word from vba in Excel is problematic. Is there some way around this? Am I going to have to make one program in word to create the certs and another in Excel to link to them? That would be inconvenient. Is what I'm trying to do even possible?

Any help would be greatly appreciated.