January 21, 2015, 07:53 AM
Danny-SRLRetrieving XL output in the workbook that generated it
Our customer has created an XL file which has values and a button.
In the button there is a URL which calls a Focexec using
http://{server}/ibi_apps/WFServlet?IBIF_ex={fexname}...params
The fex produces an XL output.
The customer would like to have the XL output returned into the calling XL workbook.
Any ideas?
January 21, 2015, 09:30 AM
SSanderHi Danny,
Depending on server setup maybe Microsoft Web Query is something to leverage here? Other option would be QuickData but that is licenced.
"Embedding a WebFOCUS Report in an Excel 2000/2003 Workbook"
http://infocenter.ibi.com/wf80...ource%2Ftopic108.htmRegards,
January 21, 2015, 04:17 PM
WazYou should be able to use VBA to call the fex. Change the results to xml, then you can process the reuslts back into the spreadsheet.
January 22, 2015, 02:34 AM
<FreSte>Daniel,
Maybe WebQuery's in XL can do the trick.
Excel Web Query -Fred-