Focal Point
[Closed]WebFOCUS using Excel Templates in Batch mode

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5387090895

February 03, 2011, 02:37 PM
Diptesh Patel
[Closed]WebFOCUS using Excel Templates in Batch mode
Hello:
Hopefully somebody can give me some ideas. I have an Excel workbook (with several worksheets) that have some complex calculations. I'd like to create an Excel Template from this workbook and reload data into this. Let the calculations do their thing, and then extract the data (calculated results). Here's the dilemma. This has to run in a Production batch mode (on the mainframe). How can I kick off a WebFOCUS Focexec in a batch mode? And would the calculated results be available if I do not 'open' the Excel Workbook?

Any tips/pointers appreciated.

Thanks,
Diptesh Patel

This message has been edited. Last edited by: Diptesh Patel,


Diptesh
WF 7.1.7 - AIX, MVS
February 03, 2011, 03:41 PM
<JG>
Excel is live it does not work as a background process, Mainframe batch is batch it has to be submitted.

If you do not open the excel how do you expect it to be able to call anything.

Rethink what you are trying to do.