×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Copy all data in MS Word Document, paste using macro to attachmate

Copy all data in MS Word Document, paste using macro to attachmate

Copy all data in MS Word Document, paste using macro to attachmate

(OP)
Hi,

I have a word document that is currently set up as a mailmerge document, tied to an excel datatable.  I'm using this mailmerge doc to copy and paste preformatted data into attachmate, for entry.  Is there a macro wizard out there that can help me?  I need the macro to copy the data in MS Word, and have it automatically switch to my AttachMate session, and paste the data followed by enter?

If there is any guidance you can provide, please let me know!
Thanks!

RE: Copy all data in MS Word Document, paste using macro to attachmate



hi,

I am confused.  How is the data you want to copy into Word, related to the data in Excel used in the mail merge?

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

RE: Copy all data in MS Word Document, paste using macro to attachmate

(OP)
Hey Skip!

Thanks for replying.  Let me see if I can explain this... I'm processing sales tracking for a number of folks in our site.  The sales tracking system exists within the AttachMate system.  We need to enter roughly 2000 items into this system, one by one.  To isolate them, we compile all of the data into an excel document, with particular columns dedicated to specific data types.  The data in excel is fed into a word document that is set up to mirror the AttachMate system's fields.  Using MailMerge, we extract the data from excel, into word, so that all of the individual data points are in the correct place.  Then, in word, we select all, copy to clipboard, paste to attachmate, and hit enter to process the referral.  We repeat this process for each individual entry, cycling through the mail merge records to get to each entry.

Does that make sense?  We are trying to find a way to automate the copy/paste process.  If we are able to do it using word, great. If we could use excel, even better.

Let me know your thoughts.
Thanks!
Matt

RE: Copy all data in MS Word Document, paste using macro to attachmate



so there's no UPDATE screen in your system?  

Usually a particular update screen accepts data in specific row/column locations, while other parts of the screen are not updatable.

BTW, Attachmate is not a system, but it is a screen (input/output) emulator for some other system, like IMS, VM, TSO etc.

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

RE: Copy all data in MS Word Document, paste using macro to attachmate

(OP)
Hey again Skip,

Thanks for all of your comments thus far.  The AttachMate system is already configured for a TN3270 connection to our back end Sales Tracking System.  The AttachMate connection is managed, and we cannot change anything about it.  I do however have the ability to write macros for the session.  You'll have to forgive me, I'm not a pro when it comes to AttachMate, so I'm not sure what you mean by update screen.  There is a particular screen I navigate to, SNME, that has specific fields that are updatedable, while the rest of the screen is locked out.  This is the screen we are pasting the word document details into, as they are set to automatically populate the correct fields upon pasting.

Does that help?

RE: Copy all data in MS Word Document, paste using macro to attachmate



okay.  Extra VB is rather clunky and I never use it.  I most often use Excel VBA to manipulate the emulator. Excel or Word VBA has much more flexibility than Extra VB.

I'd suggest checking out the FAQ area, both in this forum and in forum99: AttachMate solutions, which would be more appropriate if you are going to be running a macro.

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close