Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [Closed]WebFOCUS using Excel Templates in Batch mode
Go
New
Search
Notify
Tools
Reply
  
[Closed]WebFOCUS using Excel Templates in Batch mode
 Login/Join
 
Gold member
posted
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
 
Posts: 79 | Location: Warren, NJ, USA | Registered: October 25, 2006Reply With QuoteReport This Post
<JG>
posted
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.
 
Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [Closed]WebFOCUS using Excel Templates in Batch mode

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.