How can I save an MSChart graph to a file? I have tried all manner of methods using the ClipBoard and the RichTextBox. I need to send a copy of the graph in an email, either in the body or as an attachment.
When I try to capture the MSChart by calling EditCopy, in the program it always returns a number about 10 digits long. It is a different number every time (sometimes negative) and has no relationship to the data in the graph. Yet, when I pause the code after calling the EditCopy and launch Word, the behavior of the manual paste is correct
For I = 1 To 100000
If Clipboard.GetFormat(8) = True Then
Open fname For Output As #ff
Print #ff, Clipboard.GetData(8)
The file contains this value: -804975683
I am obviously missing something. What its it?