Copy/Paste VB

[obeast215]

Good Afternoon,

I am trying to create a macro that will copy and paste from the 3270 IBM Reflection program to either Microsoft Access database or Microsoft Excel. I already understand the mapping, i.e. column and rows, how to highlight what I want. But I don’t understand how to take that information via macros and paste it into the Access or Excel spreadsheet. I have already learned how to paste from Access to 3270 to run the repetitive reports that I used to have to do manually. Now I would like to use the macros to pull the information that I pull repetitively. Can anyone help please? Give me a string to copy anything, even a letter from 3270 IBM Reflection or anything, with that I can figure out how to rewrite the information to move all the data I need from the one program to Access or Excel. If no one knows how to do this, can someone please direct me to where I could find an answer on this?

Thank you very much
Shayne

[danp129]

I would start by searching the manual for "copy".

It may look something like this:

Sub ClipboardDemo()
'
' ClipboardDemo Macro
' Macro created <today's date> by <your name>
'
' Copy screen text to the Clipboard
'
Dim displayText As String
displayText = Session.GetDisplayText(1, 1, 80)
Session.SetClipboardText (displayText)
MsgBox "Screen text has been copied to the Clipboard."
End Sub

This may or may not be of some help to you:
http://www.ibm.com/developerworks/ra...ary/04/r-3170/