as400

  1. MCTampa

    DateSerial Function in VBA for PCOMM Emulator

    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...
  2. M

    Automation object call from excel macro on windows 2008 r2 terminal server fails with run time error 429

    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...
  3. J

    AS400 and Excel

    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...
  4. theYaniac

    AS400 information imported to excel

    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...
  5. U

    Userform User/password runs a macro

    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...
  6. D

    IBM Data transfer Plugin not working with 365 ProPlus

    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...
  7. B

    Visaul Basic 6.0 Error- AS400

    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! :)
  8. M

    Excel query using Transfer Data from System i

    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...
  9. D

    SELECT INNER JOIN query from multiple AS400 data sources with ADO?

    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...
  10. E

    Excel VBA connection help AS400 iSeries

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top