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:

Sub copyPasteList()
    'copies selected list from excel to list in JDE data selection
    
    'update log:
    
    Set cArea = Selection
    For Each c In cArea
        c.Select
        Selection.Copy
        AppActivate "Version Prompting - Windows Internet Explorer"
        SendKeys "{Backspace}"
        Application.Wait (Now + TimeValue("0:00:01"))
        SendKeys "^(v)"
        Application.Wait (Now + TimeValue("0:00:01"))
        SendKeys "{Enter}"
        Application.Wait (Now + TimeValue("0:00:02"))
        AppActivate "Microsoft Excel"
    Next c
End Sub
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,