Hi,
I'm trying to copy information from VB6 to MS Excel which works fine until I wanted to copy information from a MSChart object. I have placed the information on the clipboard and if I manually past the information from within Excel it works just fine, but what syntax do I use to have the information past from within VB?

This is what I have used so far:
Set ExcelSheet = obExcelProg.Sheets(intSheetno)
'Display the graph's heading
ExcelSheet.Cells(1, 1).Value = lblGraphHeading.Caption
'Copy the Chart information
chGraph.EditCopy
'Paste the information into Excel
???????

I hope someone can help me out here,
Thank you!