>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?
Michael McLain