I am working with Excel and Macro from a long time. VBA is my best area excel. I use to connect excel with external database like MSSQL, MYSQL, SYBASE, etc. to get the data and process and publish the result in excel to save time and money. Even I have created macro to fetch data from Linux as well to create a report in excel. There is nothing impossible the only thing required is view and logic.