Friday, April 1, 2011

Let Excel work for you

Why not let Excel work for you? Do you need, as your daily work, import data from other sources like Oracle, Access, Outlook (or other) to fill you workbook? Do you have to do a manual work to get your reports with new data?
Why not to stop doing that and create a workbook with macros and VBA code to do the work for you?
For example, imagine that you need get data from Oracle on a daily basis at 09h00m. Excel can do it alone, getting new data, update your workbook refreshing your data, saving as you want and finally send you an e-mail. So when you arrive at your office you will have the report “on your desk”. Have you thought about it?

No comments:

Post a Comment