Excel Reporting

Hello All,
Is it possible to show the Ignite ( Web browser based reports) in excel using macro.. Ignite authorizes using user id / pwd.. How to do that ?


If the above is not possible, I Have SQL server where I query to get certain values in my AIX Server... Is it possible to retrieve the values from excel macro and refresh it certain interval ( calling the script in AIX box every 2 mins and refresh the excel dashboard accordingly ).

Pls suggest. Thanks!

You should give your post a better title - this will benefit you because people who have expertise in the area you require will be more likely to click on it.

However, to be honest, I expect most of us won't have "Ignite"... as a result I'm not sure you are going to get a solution (because we would be working blind), however your chances might be better if you give some more information like screen shots etc or any progress you have made so far.

Thanks,
Here my requirement...

1. I need to pull data ( Select User name from .table ) from SQL Server and create a dashboard in excel to show it.... How can I perform it... thanks for suggestion!