Screen Scraping from/to AS400 from/to Excel

[krs66]

Years ago, I used to screen scrape data from/to AS400 using VBA in Excel to process the data.

I am looking for help in creating the interface between VBA and AS400. Can anyone help me?

Thanks,

Keith

 

[Oorang]

How you do it depends on what emulator you are using. The first step would be to go to Tools>References and check for any library that has similar name. Another way to go is just to browse to where the emulator is at and see what dlls/exes it will let you refer too.

Additionally, many emulators, such as IBM Personal Communicator have documented their vb libraries quite well including help files, and programming guides via the website.

 

[jstein]

krs66, I am trying to figure out how to copy things from as400 and paste them to excel or word. I figured out the copy part but I can't figure out how to "activate" excel or work and paste the info. It sounds like you've done what I'm trying to do. Care to share?