1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2003
    Rep Power

    Question 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
    MsgBox OLE1.Class
    Set sheet = CreateObject(OLE1.Class)
    worksheet = sheet(0)
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2003
    Melbourne, Australia
    Rep Power
    If you want to dump a whole table to Excel, use the following link:

    Also, try searching Google with ASP + Excel

    How can I soar like an eagle when
    I'm flying with turkey's?

IMN logo majestic logo threadwatch logo seochat tools logo