Upload Excel Worksheets to AS400 with VBA

[cutieme]

Hi Folks,

I have an excel workbook with multiple worksheets. First worksheet have the login information of the user and there is a button to upload all worksheets corresponding to different tables in AS400. Worksheet name are the same names as the AS400 table names.

I have this code for the upload button as below:

Please Login or Register  to view this content.

How can I insert each worksheet (with column headers) into AS400?

Please help as I am a newbie with Excel and AS400.

Thank you so much.