Hi everyone, I was hoping someone could tell me if there is an easier way to get the results from an MSGraph displayed in a listbox.
When the graph is created .EditCopy - copies the graph to the clipboard, so i have the code
results = Clipboard.GetText(vbCFText)
Results does hold the data i require but it has lots of end of line characters (chars like |123 |323) but it doesnt paste correctly.
Listbox.additem Results
How can i get rid of these characters??
Or is there anyother way?
Another query i have is - can i not paste an MSchart to a word document within VB ie not having any macros using paste special the word document.
Any suggestions would be greatly appreciated!
When the graph is created .EditCopy - copies the graph to the clipboard, so i have the code
results = Clipboard.GetText(vbCFText)
Results does hold the data i require but it has lots of end of line characters (chars like |123 |323) but it doesnt paste correctly.
Listbox.additem Results
How can i get rid of these characters??
Or is there anyother way?
Another query i have is - can i not paste an MSchart to a word document within VB ie not having any macros using paste special the word document.
Any suggestions would be greatly appreciated!