Results 1 to 2 of 2

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

Threaded View

  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

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