This may help http://answers.microsoft.com/en-us/o...4-66a08e4b62ac

This link contains code which almost achieves what I want - except it relies on closing Excel application and I'd prefer to use API rather than WScript.