Hi,

I have limited knowledge and experience in Macro VBA and now I'm given a project where I need to automate a certain process to reduce, if not eliminate, repetitive tasks. I would appreciate if someone, anyone, could give me any insights as to how I can copy data from excel spread sheet and paste it to a Personal Communications mainframe.

I need to go back and forth between Excel and PCOMM mainframe as the data needs to be copied in bits / pieces (line per line item). Is there a way to make this work?

There would be about 12-15 lines in total (rows) that I need to copy one by one from Excel and paste to PCOMM mainframe, then make the mainframe to go to the next screen (pressing Enter twice if via manual transaction), and then continue the copy-paste transaction.

I am using Windows 7, MS Excel 2013 and IBM Personal Communications Version 5.0 which says it was for Windows 95, 98, NT and 2000.

Thank you so much in advance


Kriz