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

    Join Date
    Jun 2003
    Posts
    3
    Rep Power
    0

    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
    Location
    Melbourne, Australia
    Posts
    212
    Rep Power
    12
    If you want to dump a whole table to Excel, use the following link:
    http://www.aspalliance.com/stevesmit...eltutorial.asp

    Also, try searching Google with ASP + Excel

    http://www.google.com.au/search?q=AS...-8&hl=en&meta=
    How can I soar like an eagle when
    I'm flying with turkey's?

IMN logo majestic logo threadwatch logo seochat tools logo