[AccessD] Plant an Excel Worksheet on a form?

Arthur,

You can use e.g. Unbound Object Frame - see online help for more details 
like this sample code:

Sub Command1_Click
    OLE1.Class = "Excel.Sheet"    ' Set class name.
    ' Specify type of object.
    OLE1.OLETypeAllowed = acOLELinked
    ' Specify source file.
    OLE1.SourceDoc = "C:\Excel\Oletext.xls"
    ' Specify data to create link to.
    OLE1.SourceItem = "R1C1:R5C5"
    ' Create linked object.
    OLE1.Action = acOLECreateLink
    ' Adjust control size.
    OLE1.SizeMode = acOLESizeZoom
End Sub

Shamil

----- Original Message ----- 
From: "Arthur Fuller" <artful at rogers.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Saturday, February 18, 2006 10:20 PM
Subject: [AccessD] Plant an Excel Worksheet on a form?


> Is it possible to plonk an Excel worksheet directly onto an Access form? 
> Or
> should I be content with invoking Excel and passing the filename to it?
> TIA,
> Arthur
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com