Clipboard to table question

[ckrows]

I am working with a Reflections HP session and i created a macro within the VBA editor in Reflections where i copy to the clipboard the information i need. Now the issue is that i do not know how to get it from the clipbaord to either the table i need or on the form i have, either one will work really, Form would probably be easiest. Any assistance on this topic would be great and appreciated.

 
Public Sub PasteData()
        '****Copy starts here
 
    'CR = Chr(Reflection1.ControlCodes.rcCR)
    'ESC = Chr(Reflection1.ControlCodes.rcESC)
    Dim Tcode As String
        Tcode = Session.GetText(3, 28, 3, 31)
 
    With Session
 
 
            'rst!Taxcode = strtaxcode
            'rst!Quarter = Quarter
            'rst!year = year
            'rst![Payee ID] = Trim(CStr(.GetText(8, 6, 8, 36)))
 
 
        .Transmit "58FR" & CR
        .StatusBar = "Waiting for Prompt: PRESS <RETURN> TO CONTINUE"
        .WaitForString ESC & "&a23y00C                                                   PRESS <RETURN> TO CONTINUE", NEVER_TIME_OUT, rcAllowKeystrokes
        .StatusBar = ""
        .GetText 3, 28, 3, 31
        '.SelectText StartRow:=3, StartColumn:=28, EndRow:=3, EndColumn:=31
        ' Press EditCopy (Copy the selection and put it on the Clipboard).
        .Copy rcSelection, 0
        'DoCmd.TransferText acImportFixed, , "tblPayeeCNET"
        rst!payeeidcent = Tcode

[puppydogbuddy]

See this link for Functions to copy to and from the clipboard and an ms access form.

Microsoft Access tips: Clipboard Functions (32-bit)