×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Our programs are increasingly being used to generate EXCEL spreadsheets instead
of reports. Until recently, we just called a program to copy the i5 file to the
IFS as a CSV file.
We now have a small JAVA application that converts the CSV to XLS.
Added to that, we use RPG and JAVA to send the file automatically by email to
the user.
Now I have an application that sends 3 files. The result is 3 different
spreadsheets. I'm having a few problems because I'm having to depend on JAVA
programmers when things don't work properly.
As an alternative, I have created a spreadsheet with a macro that imports the 3
files as 3 sheets. That way the user only has one spreadsheet to open.
I get the results without depending on any JAVA application and I have complete
control over the presentation, etc.
The problem : I'm generating around 20 000 lines and the macro takes a minute
and a half to work. This is quicker than using the JAVA application but that
runs in batch.
How do I get my spreadsheet to the user only after the macro has been executed ?
TIA
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
