T
Texernie1
Hello,
I apologize if this is in the wrong group.
I am creating a database that will chart some data from tables. The charts
are XYScatter graphs, and I have successfully created them through OLE in
Excel, since Access doesn't have scatter graphs. What I am trying to do now
is get a picture of that chart (and later some statistics in a cell range)
back
into Access so I can store it in a table for usage later, without recreating
the
chart.
The method I had planned on using to get the data to the clipboard is the
[Chart Object].CopyPicture method. This errors out at times though and I
don't know why.
I have the following variables defined and pointing the the appropriate
places.
Dim Xl As Excel.Application
Dim Wkb As Workbook
Dim Sht As Worksheet
Dim Cht As Chart
Dim Cel As Range
Does anyone have any code or examples of how to get a picture back from the
clipboard?
I have found some code in the newsgroups using the clipboard object (like
Clipboard.getdata), but I don't seem to have a reference pointing to it in my
project.
Thanks for any help you can provide.
Texernie1
I apologize if this is in the wrong group.
I am creating a database that will chart some data from tables. The charts
are XYScatter graphs, and I have successfully created them through OLE in
Excel, since Access doesn't have scatter graphs. What I am trying to do now
is get a picture of that chart (and later some statistics in a cell range)
back
into Access so I can store it in a table for usage later, without recreating
the
chart.
The method I had planned on using to get the data to the clipboard is the
[Chart Object].CopyPicture method. This errors out at times though and I
don't know why.
I have the following variables defined and pointing the the appropriate
places.
Dim Xl As Excel.Application
Dim Wkb As Workbook
Dim Sht As Worksheet
Dim Cht As Chart
Dim Cel As Range
Does anyone have any code or examples of how to get a picture back from the
clipboard?
I have found some code in the newsgroups using the clipboard object (like
Clipboard.getdata), but I don't seem to have a reference pointing to it in my
project.
Thanks for any help you can provide.
Texernie1