none
Can't open Excel 2010 Workbook project with VS2012 and Office 2013 RRS feed

  • Question

  • Hello,

    I've changed my Dev computer recently and it has been setup automatically with VS2012 and Office 2013 by our IT Service.

    I've to work on an existing project "Excel 2010 Workbook" using VS2012 and Excel 2013. But it seems it's not possible.

    I can't find any requirements on specific version of Office or VS to use a such combination.

    Here, it's seems that I shouldn't have any problems => http://msdn.microsoft.com/en-us/library/bb398242(v=vs.110).aspx

    Thanks for your help.

    David.

    Wednesday, January 29, 2014 6:24 PM

Answers

  • Hello David,

    I don't see any difficulties in developing such type of project in Visual Studio 2012.

    But you should have Office 2010 installed on the machine (not 2013) if you are going to develop Excel 2010 Workbook customizations:

    Visual Studio 2012 does not support creating Office solutions when the development computer has a version of Office 2013 or Microsoft Office 2010 that was delivered by means of Click-to-Run.


    • Edited by Eugene Astafiev Wednesday, January 29, 2014 6:49 PM
    • Proposed as answer by George HuaModerator Thursday, January 30, 2014 3:27 AM
    • Marked as answer by dwi.fr Thursday, January 30, 2014 10:02 AM
    Wednesday, January 29, 2014 6:47 PM

All replies

  • Hello David,

    I don't see any difficulties in developing such type of project in Visual Studio 2012.

    But you should have Office 2010 installed on the machine (not 2013) if you are going to develop Excel 2010 Workbook customizations:

    Visual Studio 2012 does not support creating Office solutions when the development computer has a version of Office 2013 or Microsoft Office 2010 that was delivered by means of Click-to-Run.


    • Edited by Eugene Astafiev Wednesday, January 29, 2014 6:49 PM
    • Proposed as answer by George HuaModerator Thursday, January 30, 2014 3:27 AM
    • Marked as answer by dwi.fr Thursday, January 30, 2014 10:02 AM
    Wednesday, January 29, 2014 6:47 PM
  • OK So for Workbook Customization, I should have the corresponding version of the product, is that right ?

    A bit annoying...is it possible to install both version of Excel ?

    Thursday, January 30, 2014 8:22 AM
  • Nope. Actually, you are allowed to install both versions of Excel. But Visual Studio doesn't support such scenario.

    Please take a look at the Configuring a Computer to Develop Office Solutions article in MSDN which states the following:

    Visual Studio 2012 does not support creating Office solutions when more than one version of Microsoft Office (or different versions of individual Office applications, such as Excel 2007 and Excel 2010) are installed side-by-side on the development computer. To create Office solutions by using the Office developer tools in Visual Studio 2012, install only Microsoft Office 2010 or Microsoft Office 2013 on the development computer.

    Also you may find the Why is VS development not supported with multiple versions of Office? article helpful.

    Thursday, January 30, 2014 9:58 AM