as400

I am building a macro to change values in our IBM AS400. I need my macro to evaluate each line and determine if the date for that line satisfies a criteria. My dates are formatted as such: 01APR19 These value are on row 7 starting with position 51 (the 0) and ending with position 57 (the 9) I...

Since this is my first question on Mr. Excel, I thought I would make it a doozie lol. I am trying to convert a macro written for 32-bit Excel that feeds data into the IBM AS400 mainframe. I have read articles like the one found here which state that the issue I am having is "....a permanent...

Good day everyone! We always encounter a problem with our billers that uses AS400 for bill entry process. They usually miss important information or required details that needs to be be placed on AS400. The information are specific to each customer and it is listed on an excel sheet. Is it...

I am looking for some help to find a way to import information from the AS400 system into an excel spreadsheet. For those not familiar with AS400 it is a very archaic program. All information taken from AS400 needs to be manually typed into a new spreadsheet in excel. I am hoping someone on...

Hi all, I have a macro that retrieves data from AS400 (ISeries) and it saves in an excel format file. The point is that to run the retrieve it is mandatory to enter en username and a passaword. My macro works when there is just one user, because I declare I enter both variables in the code. But...

My company use an IBM data transfer Excel Add-in to import and export data from our legacy systems(AS400) which has lost functionality with the newer version of office. Some users are reporting an issue where the Add-in will work once after adding and enabling the addin, but will do nothing...

Anyone does have idea what or how to edit the code when AS400 change/update the version from 5.1 to 5.9? Thanks in advance! :)

I am looking for information on how I can use the Transfer Data from System i Add-In for Excel to only get data that equals the data in one of my columns (both sets of data are strings). Unfortunately, I cannot just get the entire contents of the System i table since it contains more than the...

My current Access + Excel solution: I use an Access database to create two pass through queries. Each pass through query selects records from different AS400 data source. I then use a third (regular... not pass through) query to INNER JOIN the two tables on a common field. The records returned...

Hello, I am testing using Excel VBA to connect to AS400 for simple getstring & putstring operations. I am able to pull data from AS400 but am not able to put data onto the active screen using either SendKeys or putstring commands. My code does not throw any errors and I am not able to figure...