Running display program using macro and input from spreadsheet

15 pts.
Tags:
iSeries
iSeries macros
Microsoft Excel
Is there a way to create a macro (either from the iSeries or Excel) to copy/paste data from a spreadsheet into an iSeries screen and then invoke keystokes to perform an action within the interactive program?

Software/Hardware used:
iseries, jdedwards world 9.3, excel2007

Answer Wiki

Thanks. We'll let you know when a new response is added.

 .

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • BigKat
    if you are referring client access macros, then not really.  But, you could possibly simulate it by using a Word "mail merge" to insert different data sets into a "letter" that is the macro script text and save multiple new macros.
    8,100 pointsBadges:
    report
  • ToddN2000
    I try to avoid macros that are that complex. If the macro is launched at the wrong position it can cause too many issues. It's also something that may need to be updated any time there is a software update or new release. In your instance I agree with BigKat. I don't think you can have a cut/paste macro work from excel to a client access screen. I know if you try and cut and paste things like a subfile from the I-series into Excel the formatting does not copy over.
    9,905 pointsBadges:
    report
  • KevinCmyrgroup
    Thanks for the feedback.  From what I tried, it did seem remote that this would work and even if it did, would it be stable.  I remember that at my last company we had a warehouse guy (who was their tech laision) write a script to simulate entering picking data for big pushes where the item and quantity where the same.  And as you both pointed out, the script would invariably hiccup at some point, generate an error within the program because it didn't know how to handle the error.   On to plan B.  Thanks again for your input.
    15 pointsBadges:
    report
  • BigKat
    there are software packages that can record your keyboard and mouse activity and replay it with new data.  I just can't remember the name, but search on automated testing tools

    8,100 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following