Slowing of office automation on XP SP2
Posted on 2004-10-22
I have an established MS Office automation application (written in VB) which until now has run quite happily on all Windows O/S and all versions of office. I recently ran it on a new PC which shipped with XP SP2 pre installed, and Word and Excel documents which used to take 3 seconds to create now take around 110 seconds to create. I also now get clipboard access errors where none would appear before. I am currently running it against Office 2000.
As the application is Office version agnostic, it is late binding - I wondered if the calls to getobject and createobject may have been the problem, and produced an early binding version which suffered the same problems. I have also been through all the XP services turing off as much as possible, switched off the DEP (well as far as you can), and no change.
Has anyone encountered a similar problem, and if so is there a work around?