Posts by efarhat

    Andy,


    I don't think this code is working. I'm not using VBA. I'm using VB. I have a form with an image control on it and I want to import the Excel chart either as an object or image, I have no preference. (good idea) Do you know how to do it in VB?


    Essa

    I'm not sure if it's possible to even do this but I need to import several excel charts into a form, just for displaying. It's easier to create the charts in excel and then import (i think). I have more control in excel with the design. Well, now i have to figure out how to import them. Is this possible? if so, how?


    I already have this declared but where do i take it from here?
    Dim XL As Excel.Application, XLW As Excel.Workbook, XLS As Excel.Worksheet
    Set XL = New Excel.Application
    Set XLW = XL.Workbooks.Open(filename)
    Set XLS = XLW.Worksheets.Item(1)