469,898 Members | 1,792 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,898 developers. It's quick & easy.

Copy/Paste VB

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 dont 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
Oct 29 '07 #1
1 2168
danp129
321 Expert 100+
I would start by searching the manual for "copy".

It may look something like this:

Expand|Select|Wrap|Line Numbers
  1. Sub ClipboardDemo()
  2. '
  3. ' ClipboardDemo Macro
  4. ' Macro created <today's date> by <your name>
  5. '
  6. ' Copy screen text to the Clipboard
  7. '
  8. Dim displayText As String
  9. displayText = Session.GetDisplayText(1, 1, 80)
  10. Session.SetClipboardText (displayText)
  11. MsgBox "Screen text has been copied to the Clipboard."
  12. End Sub

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

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Legendary Pansy | last post: by
3 posts views Thread by Rachel Suddeth | last post: by
2 posts views Thread by Matt | last post: by
7 posts views Thread by lgbjr | last post: by
6 posts views Thread by Ben R. | last post: by
17 posts views Thread by Steve | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.