Hello,

I'm hoping someone may be able to point me in the right direction with this;

I currently have a column of data in Excel that can range from typically 50-80 cells to upwards of 100s and I need a way to take each value one at a time and move it to a textbox in JDE and hit "Submit" so that it is added to the listbox and repeat this until it hits the end of the data column.

Currently I am using a send key method as such:

Please Login or Register  to view this content.
Which does work, but its quite slow and a huge pain for those larger datasets as any slight key press by a user can interfere with it severely.
Any help would be greatly appreciated as I am quite knew to Excel macros/programming and trying to refresh myself in programming in general.


Thank you,