June 21st, 2003, 02:32 PM
Join Date: Jun 2003
Time spent in forums: 46 m 48 sec
Reputation Power: 0
How can I populate data to Embedded Excel OLE in Form??
Thank you for Your interest..
First, I used MSFlexGrid control to display data
However, My client want to copy and paste some part of the data to other Office application.
So, I thought I have to use Embedded Excel using OLE control so that I don't worrry about the copy paste feature..
But, I don't know how to populate data into the embeded Excel OLE in run time..
I tried all ways.. like following..(feel stupido... --.-- )
Please help me.. I need code snippet. Or If you have any example using this feature..I will be big help or link...
Dim sheet As Excel.Sheets
Dim worksheet As Excel.worksheet
Set sheet = CreateObject(OLE1.Class)
worksheet = sheet(0)