This is reasonably doable with a high level scripting language (Perl, Python) and OLE. I only fiddled with the OLE stuff once about 15 years ago but had it working with just a couple days of effort -- was pulling call data from a PBX and building fancy executive reports with it. Anyway, below are some links to look at or otherwise try searching for OLE tutorials for the programming languages you're capable with.
Perl: Win32::OLE - OLE Automation extensions - metacpan.org
Python: http://www.python-excel.org/