I made some experiments with Excel and manager last summer. Working with the old APIs is completely impractical. It would be better to have an additional different authentication system throughout the whole software in order to allow Excel to get data through webtables.