Excel to Flexgrid

[Boris10]

Hi i know this topic has been discussed numerous times, however, i am failing to implement solutions that i found on the net. Could any one assist me. How can i copy a range of cell (from a single column) from an already opened Excel document and paste them respectively into a flexgrid column?

 

[SkipVought]

hi,

What have you tried already? Please post your code and all relevant information.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Boris10]

Hi Skip,

Got this code to finally copy what i want from excel. However, when it comes to text and alphanumeric strings i get a small icon at the end of each string - looks like a T. How can i avoid that?

This is my code

ClipBoard.GetFromClipboard
    With ItemGrid
     
        If Srow > 0 And .col = 1 Then
            .row = Srow
            .col = Scol
            .RowSel = .Rows - 1
            .ColSel = .Cols - 1
            Stext = ClipBoard.GetText
            .Clip = Mid(Stext, 1, Len(Stext) - 1)
            .FillStyle = flexFillSingle
        End If
    End With

 

[SkipVought]

.clip = Left(stext, len(stext)-2)

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Boris10]

Hi Skip, thank you for your time. Got around the problem with your help!

 

[SkipVought]

I think that I would be more inclined to do it this way, however...

.clip = Split(Split(Split(ClipBoard.GetText, vbLf)(0), vbCr)(0), vbTab)(0)

rather than assume that the last two characters in the string are ALWAYS control characters.


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}