>For the 4th step, I've tried things like: ActiveCellFormulaR1C1 = "the desired text"


That should be:
ThisForm.oExcel.ActiveCell.FormulaR1C1 = "the desired text"

Did you have the period between ActiveCell and FormulaR1C1 or was your message post a typo?