<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
<br />
I use a web based data tool called Cognos, its in the IBM family i believe.<br />
<br />
I run reports off it, i download the extracts to &nbsp;excel format and then do my work.<br />
<br />
Is it possible using vba or linking, to call those reports directly to excel so i dont need the download<br />
<br />
Many thanks
</div>
</div>


Hi,


I use a web based data tool called Cognos, its in the IBM family i believe.

I run reports off it, i download the extracts to  excel format and then do my work.

Is it possible using vba or linking, to call those reports directly to excel so i dont need the download

Many thanks

Cognos / IBM extract - call to excel

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.

DB Reporting Tools

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.