I have a VB program that produces reports by sending text to various list boxes.
I want to add the option to have the reports sent to the clipboard. I imagion most users would then want to paste the information into a spreadsheet.
I have figured out that adding chr$(13) to the end of each line of text will make the text in the clipboard appear on the next line.
1. Is there a character I can add to the string that would make the next part of the string (when pasted into a spreadsheet) appear in the next spreadsheet column.
2. Is there an easy way to send all the text that is already in the list box to the clipboard, or will I have to create a huge string to do this.