I use the following code from the help file:
OLE1.Class = "Excel.Sheet"
OLE1.OLETypeAllowed = acOLELinked
OLE1.SourceDoc = "C:\Excel\Oletext.xls"
OLE1.SourceItem = "R1C1:R5C5"
OLE1.Action = acOLECreateLink
This works just fine except that it I can't figure out how to specify a different sheet as SourceItem
I tried several variations on OLE1.SourceItem = "'Sheet 2'!R1C1:R5C5", but nothing seems to work.