1 Attachment(s)
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:
Option Explicit
Private Sub Form_Load()
ISPanel1.Attatch Picture1
End Sub
Private Sub Form_QueryUnload(Cancel As Integer, UnloadMode As Integer)
ISPanel1.Detatch
End Sub
Private Sub Toolbar1_ButtonClick(ByVal Button As MSComctlLib.Button)
End Sub
Private Sub Picture1_Click()
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. :(
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! :)