We have a program which allows users to export data to Excel. This is implemented via OLE automation. In the last 2 weeks this stopped working on my computer. I am running Windows 7 Professional and Office 2007. On a second computer which also has Windows 7 and Office 2010, we found that the same problem existed, but if we run our program 'As Administrator', the export to Excel functionality works. so I thought I had found the solution. However trying this fix on my computer does not make any difference.

I suspect that one of the Window 7 or Office updates has added some security which prevents OLE Automation from working.

Has anyone else experienced this kind of problem in the last two weeks or have any suggestions for resolving this.