excel2as400.txt

<div>
Hi,<br />
<br />
I cant remember exactly what it test, But I think, the script is first looking to the program-name on the left upper corner (or right)<br />
that must be the name corresponding with the data you will let the macro enter.<br />
<br />
Every error on the bottom row wil be checked and in case of errors the excel line wil be marked in red.<br />
processed lines in green.
</div>


Hi,

I cant remember exactly what it test, But I think, the script is first looking to the program-name on the left upper corner (or right)
that must be the name corresponding with the data you will let the macro enter.

Every error on the bottom row wil be checked and in case of errors the excel line wil be marked in red.
processed lines in green.

<div>
<div class="content wysiwyg-content">
Hi, I need a macro for as400 which will take info from an excel spreadsheet and copy/paste the info into as400 and then go back to the spreadsheet until all the rows are processed. &nbsp;(Ex, cell A1 is an account #, B1 is a date (no slashes) &amp;&nbsp;C1 is text). &nbsp;I'd like it to process through each row and paste the info into as400. &nbsp;I have to use the sendkey command at the appropriate times between pasting some of the info. &nbsp;Does anyone have anything that can help me accomplish this?
</div>
</div>


Hi, I need a macro for as400 which will take info from an excel spreadsheet and copy/paste the info into as400 and then go back to the spreadsheet until all the rows are processed.  (Ex, cell A1 is an account #, B1 is a date (no slashes) & C1 is text).  I'd like it to process through each row and paste the info into as400.  I have to use the sendkey command at the appropriate times between pasting some of the info.  Does anyone have anything that can help me accomplish this?

as400 Macro to copy/paste info from excel

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

IBM i, formerly known as AS/400, is a proprietary, midrange, object-based operating and application system. It includes a relational database, a menu-driven interface, support for multiple users, block-oriented terminal support and printers, and supports security, communications, and web-based application servers including Websphere, Apache and Tomcat.