Problem solve Get help with specific problems with your technologies, process and projects.

Launch Excel sessions on client machines

Here's how to launch Excel sessions on client machines -- these can even be called from green-screen menu options.

This sounds like a lot of steps, but it works great. You don't have to worry about ODBC, or security of your data since they have their own copy they can do whatever they want with.

All you need is to copy the following code from Craig Pelkie.

This code returns the TCP/IP address of the remote client.

You then do the following:
1. Call the above code to get the remote IP address.
2. FTP the data from the AS/400 to a PC server.
3. Call RUNRMTCMD to the PC server to format the data how you want it (we use Excel Macros).
4. Then use RUNRMTCMD to the remote PC to open the final resulting Excel Spreadsheet.

This was last published in July 2001

Dig Deeper on iSeries CL programming

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.



  • How do I size a UPS unit?

    Your data center UPS sizing needs are dependent on a variety of factors. Develop configurations and determine the estimated UPS ...

  • How to enhance FTP server security

    If you still use FTP servers in your organization, use IP address whitelists, login restrictions and data encryption -- and just ...

  • 3 ways to approach cloud bursting

    With different cloud bursting techniques and tools from Amazon, Zerto, VMware and Oracle, admins can bolster cloud connections ...