0

Hi,

any idea how to copy row and column data from msflexgrid to excel, I have tried looping from the selected rows and columns of msflexgrid using "VbTab" and "vbCrLf" and clipboard.setText, "vbCrLf" seems to work in separating the data into rows but data to column seems to have some problem

i have also tried using msflegrid.clip but i'm still coming up with similar results.. data to row is ok, but data to column is not

my Code:
Dim tmpCnt As String
Clipboard.Clear
tmpCnt = "a" & vbTab & "b" & vbCrLf & _
"c" & vbTab & "d" & vbCrLf & _
"1" & vbTab & "2"
Call Clipboard.SetText(tmpCnt)

thanks

2
Contributors
2
Replies
3
Views
10 Years
Discussion Span
Last Post by paramasivan
0

Hi,

I found out that there is nothing wrong with the code, I tried "paste" to text document and notice that the "Tab" was still present

when I checked the sheet where I want to paste the clipboard the delimiter filter was set to comma, so I assume that this is the reason why my TAB was not working... I change the "VbTab" to Chr(44) then it works

but still I need other confirmation about this or better solution

thanks

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.