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)