Excel 2007 problem "don" <don[ at ]home> 5/24/2007 8:56:41 AM Can anyone help? I recently installed Excel 2007 (as part of Office 2007 installation) on a Vista platform and everything worked fine - although still trying to understand what happened to some of the previously cherished commands that I used in Excel. However, after installing further software, I now get the following message whenever I open Excel: Microsoft Visual Basic run-time error: '-2147467259 (80004005)' Method 'Add ' of object 'CommandBarControls' failed. If I hit the end button at the end of this message Excel then seems to function OK - but I then will get the message the next time I open Excel. This is rather annoying and worrying - and the message is totally meaningless to me. Do I need to uninstall and re-install Office 2007/Excel 2007? Any help much appreciated.

Re: Excel 2007 problem "Bernard Liengme" <bliengme[ at ]stfx.TRUENORTH.ca> 5/24/2007 8:06:28 PM Sounds like a macro is trying to run. Do you have a PERSONAL workbook in the XLSTART folder? If so, temporarily rename it PERSONAL.OLD and see what happens I would suggest you ask this question in one of the Microsoft Excel newsgroups (news:microsoft.public.excel) where the are more Excel experts. Try this site to help you locate familiar XL2003 commands in XL2007 http://office.microsoft.com/en-us/excel/HA101491511033.aspx best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "don" <don[ at ]home> wrote in message news:uKlKyFenHHA.2296[ at ]TK2MSFTNGP03.phx.gbl... [Quoted Text] > Can anyone help? > > I recently installed Excel 2007 (as part of Office 2007 installation) on a > Vista platform and everything worked fine - although still trying to > understand what happened to some of the previously cherished commands that > I used in Excel. However, after installing further software, I now get > the following message whenever I open Excel: > > Microsoft Visual Basic run-time error: '-2147467259 (80004005)' > Method 'Add ' of object 'CommandBarControls' failed. > > If I hit the end button at the end of this message Excel then seems to > function OK - but I then will get the message the next time I open Excel. > This is rather annoying and worrying - and the message is totally > meaningless to me. > > Do I need to uninstall and re-install Office 2007/Excel 2007? > Any help much appreciated. > > >

Re: Excel 2007 problem "don" <don[ at ]home> 5/25/2007 11:48:33 AM Bernard - many thanks for taking the time to reply. I actually found the solution to my problem using Google which revealed the following web page. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1609140&SiteID=1 This described my problem exactly and the explanation provided there allowed me to solve the problem immediately - which made me very happy (not having to reinstall or get into anything beyond my technical capability!) Also thanks for your link to the site showing how to locate the Excel 2007 equivalents to Excel 2003 commands. In general this is very helpful - however, I still couldn't find one really useful command that is in Excel 2003 and earlier versions. In previous versions of Excel, a chart window could be displayed using the "Chart Window" command on the View menu (this command only appears in those earlier versions of Excel when you are pointing at a chart). I now find (again through Google) that the Microsoft developers in their infinite wisdom have removed this extremely useful command (which I have used continuously for many years) without mentioning this in the standard Excel 2007 info - or on the site that you linked me to. It is very frustrating to buy the latest product and feel that it has taken a very substantial backward step! The developers also list other "Deprecated Features For Charting'" in a blog at http://blogs.msdn.com/excel/archive/2006/08/28/724641.aspx and provide an explanation of the technical reasons that have driven them to exclude the command at http://technet2.microsoft.com/Office/en-us/library/bee594b4-01b1-4d17-90ca-d43735a7382a1033.mspx?mfr=true "Bernard Liengme" <bliengme[ at ]stfx.TRUENORTH.ca> wrote in message news:eGr$E8jnHHA.4024[ at ]TK2MSFTNGP02.phx.gbl... [Quoted Text] > Sounds like a macro is trying to run. Do you have a PERSONAL workbook in > the XLSTART folder? > If so, temporarily rename it PERSONAL.OLD and see what happens > I would suggest you ask this question in one of the Microsoft Excel > newsgroups (news:microsoft.public.excel) where the are more Excel experts. > > Try this site to help you locate familiar XL2003 commands in XL2007 > http://office.microsoft.com/en-us/excel/HA101491511033.aspx > best wishes > -- > Bernard V Liengme > www.stfx.ca/people/bliengme > remove caps from email > > "don" <don[ at ]home> wrote in message > news:uKlKyFenHHA.2296[ at ]TK2MSFTNGP03.phx.gbl... >> Can anyone help? >> >> I recently installed Excel 2007 (as part of Office 2007 installation) on >> a Vista platform and everything worked fine - although still trying to >> understand what happened to some of the previously cherished commands >> that I used in Excel. However, after installing further software, I now >> get the following message whenever I open Excel: >> >> Microsoft Visual Basic run-time error: '-2147467259 (80004005)' >> Method 'Add ' of object 'CommandBarControls' failed. >> >> If I hit the end button at the end of this message Excel then seems to >> function OK - but I then will get the message the next time I open Excel. >> This is rather annoying and worrying - and the message is totally >> meaningless to me. >> >> Do I need to uninstall and re-install Office 2007/Excel 2007? >> Any help much appreciated. >> >> >> > >