How to Call a Stored Procedure from Excel, Part 2

Hey, Howard:

I enjoyed "How to Call a Stored Procedure from Excel." The only concern I have is providing the password to retrieve the data. Can't the Visual Basic code be changed so that the password for the system connection is prompted? My preference is to use Worksheets().Columns().Autofit for column resizing and Worksheets().Range().Select, ActiveWindow.FreezePanes = True for locking headings in the spreadsheet.

READ MORE >

Where Is My Source Code?

Hey, Ted:

In the April 4 edition of Midrange Guru, the first tip tells how to find out which source member was used to create both OPM and ILE programs. How can I determine which source member was used to create a file?

READ MORE >

Reader Feedback and Insights: Appalled by Lack of Basic Knowledge

Hey, Ted:

I read the questions some people submit on various iSeries-related Web forums, and I am appalled by the lack of AS/400 and RPG knowledge that is out there. What are your thoughts? Does this same phenomenon exist in the Java, Windows, and Unix worlds?

Attention RPG Developers

Enhance your RPG skills by attending RPG World, three days of extensive RPG education taught by renown RPG experts Jon Paris, Susan Gantner, Bob Cozzi, and Paul Tuohy. RPG World is set for November 10-12, in Anaheim, California. Click here for more information and online registration.