IBM iSeries\Excel Interface Video 1 of 2: Excel Data Entry скачать в хорошем качестве

IBM iSeries\Excel Interface Video 1 of 2: Excel Data Entry

This is a two part video series. Part 1 shows some advantages of using Excel to prepare data for entry into the AS/400 terminal. Part 2 shows the automated entry of data from Excel into the terminal, using iSeries PCOMM Host Access Class Library Automation Objects in VBA. This video demonstrates the use of VBA code to improve the speed and accuracy of data entry tasks. The video is not narrated, so you may need to read these comments to understand the demonstration. Fields in this spreadsheet use Excel data validation drop down menus to control input and assist with data integrity. The drop down menus are populated by data supplied by iSeries using the Transfer Data from iSeries (.dtf) tool. This data can be updated from the source on demand using VBA code. Some fields can be populated automatically by code based on data supplied to other fields. Example: If Color number is entered, Color Name will be populated. (and vice-versa). Some fields can be autocompleted after a few characters are keyed. Example: In the Fabric field, the first two characters are keyed. The remainder are populated automatically upon exiting the cell. Excel allows for the creation of multiple records very quickly by using copy/paste and autofill features. This is a big advantage over item by item data entry into the terminal.