I have been playing with the Richtext control, and assuming one is instantiated as oRTF, I can insert an Excel Spreadsheet with
oXL = oRTF.OLEObjects.Add(, "Test", , "Excel.Sheet")
and after this an instance of Excel.exe is in the task manager. My question(s) are how to address the oXL (object). I can close it with
If oRTF.OLEObjects.Count>0 Then oRTF.OLEObjects.Remove(0)
but code like oXL.Save, oXL.Quit or .copyfromrecordset produce errors. I have never dealt with the sheet object as a separate entity and my difficulty is perhaps separating it from the Excel hierarchy.
Hope this makes sense.
Stan