Saving OLE embedded Excel sheet to OLE field in different table?

[GordonLeeds]

Hello OLE gurus, hope you can help me out!

I have an Excel workbook embedded in an OLE field. A command button on the form opens the workbook invisibly, creates a new tab, uses a bunch of gnarly vba to populate & format it based on data in the existing tab, and stuffs the workbook back into the OLE field. All well and good.

I want to modify this process so that it does all of the above except that it creates the new tab in a NEW workbook object (I know how to do this part) and then embeds the result into an OLE field in a new record in a different Access table.

The only way I'm seeing so far is to use the acOLECreateEmbed action, but for that it seems I have to have the destination table's new record displaying on the form (or a subform, I suppose). If this is the only way, I think I can make it work, but it will be ugly and what I'd really like is to just make a recordset, .AddNew, and save the new workbook into the OLE field. Is there any way to do this??

If so, this one will be worth a major star to my benefactor! <;-}

Regards,
Gordon