Results 1 to 2 of 2

Thread: Embedding an Excel Sheet ==>Problem...

  1. #1

    Thread Starter
    Member
    Join Date
    Dec 2004
    Posts
    34

    Exclamation Embedding an Excel Sheet ==>Problem...

    Hello again! I am now currently attempting to embed an excel file into the Vb program. I am using the ActiveX control that is attached to this message. Now my problem is this: I cannot get the scroll bars to "scroll". I copy the source code of the form in the package below, and I enter the path of my excel document. I made sure that the "Link" checkbox was unchecked so that the sheet cannot be modified. The source code of the form that I am trying to embed the sheet in is listed below. I created a frame using the control (in the file below), created a picture box inside of it, and inserted an OLE object linked to the Excel sheet I want it to display. Please help! Thank you!

    VB Code:
    1. Option Explicit
    2.  
    3. Private Sub Form_Load()
    4.     ISPanel1.Attatch Picture1
    5. End Sub
    6.  
    7. Private Sub Form_QueryUnload(Cancel As Integer, UnloadMode As Integer)
    8.     ISPanel1.Detatch
    9. End Sub
    10.  
    11. Private Sub Toolbar1_ButtonClick(ByVal Button As MSComctlLib.Button)
    12.  
    13. End Sub
    14.  
    15. Private Sub Picture1_Click()
    16.  
    17. End Sub

    I think that there should be some information in some of those Subs, but I am clueless as to what that might be.
    Attached Files Attached Files

  2. #2

    Thread Starter
    Member
    Join Date
    Dec 2004
    Posts
    34

    Exclamation Re: Embedding an Excel Sheet ==>Problem...

    Has anyone used this ActiveX control (listed as a d/l at the bottom of the first message)? If not, does anyone know how to embed the excel sheet with the full data being displayed with scroll bars to see the rest of the sheet? Thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width