Monday, January 17, 2011

Blank Microsoft Visual Basic Error occurs during Excel launch

This error was encountered during an first time Excel launch where addins had been prewritten into the users registry.  Excel launched and carried out the first time launch items such as confirming the User Name but then stalled with this error.  Some other articles have also referred this type of event happening when addins that worked under 2003, are tried in Excel 2007.  Which was true in this case as well.  The cause, therefore, appears to be the contents of the addins rather than the mechanism for configuring them for the user (the packaging).  Addins in this case were Bloomberg and Bloomberg TSAPI.  The workaround is as simple has having any of the office applications launch before Excel or launching Excel before the applications are installed and configured for the user.
Also found on this subject
http://social.answers.microsoft.com/Forums/en-US/officeprog/thread/562433ed-5365-4c2f-8a48-b68540821403
http://techrepublic.com.com/5208-3513-0.html?forumID=102&threadID=333274