Copy array to clipboard

[steven54]

I am looking for a way to copy a single dimension text array of less than a dozen elements to the clipboard so when pasting the data into an Excel spreadsheet the data is inserted into a column, not a row.

This copies the data into an array. However, when pasting the data into Excel it pastes it horizontally (a row) rather than vertically (a column).

tempString = ""
For i as integer = 0 to 5
tempString = tempString & txtMyDataBox.Text & ControlChars.Tab
Next

Any ideas?

Thanks in advance!

When a door closes another door should open, but if it doesn't then go in through the window.

 

[steven54]

I resolved it with this little chunk of code:

tempString = ""
For i as integer = 0 to 5
tempString = tempString & txtMyDataBox.Text & ControlChars.CrLf
Next

Sometimes the solution is too simple and, thus, easily overlooked

When a door closes another door should open, but if it doesn't then go in through the window.