Tip

Launch Excel sessions on client machines

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 first published in July 2001

Disclaimer: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.

Back to top