Paste OLE Object dialog settings

I am trying to use the .sendcommand key-in "clipboard paste" from a vba to embed a selected portion of a temporary excel spreadsheet into a MicroStation model and it seemed to be working fine. However I've found that if settings within the Paste OLE Object dialog have been changed from Paste as: Embedded, Method: By Size, the command won't run correctly. How can I specify the correct settings before I run the command? I don't see any documentation or anything in user preferences to do this.

Help is appreciated,

Stephanie