Displaying Excel chart image in Picturebox using VB.net

S

Stan

In the old days of VB6, an Excel chart image could be
pasted into a picture box with Clipboard using the
following commands.

xlApp.ActiveChart.ChartArea.Copy
Picture1.Picture = Clipboard.GetData()


I having problems doing this in VB.net? I tried the code
shown below, but it does not work. Its a modified version
of a Clipboard-bitmap example I found on the Microsoft
support site. I believe Excel Chart images copied onto
Clipboard as a enchanced metafile.

xlApp.ActiveChart.ChartArea.Copy

Dim oDataObj As IDataObject =
System.Windows.Forms.Clipboard.GetDataObject()

If Not System.Windows.Forms.Clipboard.GetDataObject() Is
Nothing Then

If oDataObj.GetDataPresent
(System.Windows.Forms.DataFormats.MetafilePict) Then
PictureBox1.Image = oDataObj.GetData
(DataFormats.EnhancedMetafile, True)
End If

End If


Please help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

saving bmp from clipboard to file 2
Using VB.Net or C#, utilizing the clipboard object, how to copy an MS Excel graphic from the clipboa 5
Unable to copy from clipboard 1
How do I print MSChart controls? 2
How do I open an Image and load it to a "picturebox" in ASP 1
error displaying an image in PictureBox 1
Reading metafile or gif from clipboard to picturebox 2
Pasting an excel Chart into a specific area in Powerpoint 3

Top