title: Macro to Get Data from Iseries (AS400) using Excel VBA
body: <p>I am getting data from AS400 via Excel add-in and I'm trying to find an automated to do this because I have to do this many times with various source files and it's annoying to constantly to having to log in whenever I use a new source file.</p>
  
  <p>For instance, for the source file "bond.tto" I would do this to download it:</p>
  
  <p>In Excel, 
  go to "Add-Ins" --> "Transfer Data from iSeries." A "Transfer Request" window pops up and from there I choose "create a new file"... the path and the file name is c:\bond.tto.</p>
  
  <p>"starting cell position" I chose column A and row 1 and click "include column headings."  I press "OK."</p>
  
  <p>then I enter my credentials which let's say my user name is "abc" and pw is "abc."  The server...let's call it "BLUE.TOR.MCFLY.COM."</p>
  
  <p>Could somebody suggest code to automate this?  Please and thank you.</p>
  
  <p>The macro recorder doesn't give me any lines of code to work with.
  No errors as the macro recorder doesn't work.</p>