none
VSTO 4 and Excel 2010 Book RRS feed

  • Question

  • Hi all,

    I want Book for VSTO 4 and Excel 2010.I found lot of books about VSTO from amozon but not excel 2010 and VSTO 4.

    But I found this book.

    VSTO For Dummies 

    This is relay good book but not complete guide and used VB.But I am c# man.

    Is there any book for Excel 2010 like  Visual Studio Tools for Office 2007A

    Any idea,

    Tuesday, October 9, 2012 6:24 AM

Answers

  • Hi Chamara,

    There seems have no specific pdf file for Excel 2010 development I think you’d better begin from Excel 2007 development. And I will consult others to see whether I can provide some references to you under my permission.

    Have a good day,

    Tom


    Tom Xu [MSFT]
    MSDN Community Support | Feedback to us

    Thursday, October 11, 2012 7:36 AM
    Moderator

All replies

  • Hi Chamara,

    Thanks for posting in the MSDN Forum.

    It’s based on my experience that “Visual Studio Tools for Office 2007” is good enough to guide your how to work with VSTO. VSTO 4.0 compatible with VSTO 3.0, it means that what you do under VSTO 3.0 will also work under VSTO 4.0. And if you found something which works under VSTO 3.0 but doesn’t works with VSTO 4.0, please feel free to post your question in the MSDN Forum. Community members and Microsoft’s experts will help you to solve your issue.

    Have a good day,

    Tom


    Tom Xu [MSFT]
    MSDN Community Support | Feedback to us

    Wednesday, October 10, 2012 1:44 AM
    Moderator
  • Hi Tom

    Thanks for your answer.

    Further is there any tutorials in pdf about Excel 2010 development using C#  ?

    Have a good day,

    Chamara Prasanna



    Chamara Prasanna

    Wednesday, October 10, 2012 4:30 AM
  • Hi Chamara,

    There seems have no specific pdf file for Excel 2010 development I think you’d better begin from Excel 2007 development. And I will consult others to see whether I can provide some references to you under my permission.

    Have a good day,

    Tom


    Tom Xu [MSFT]
    MSDN Community Support | Feedback to us

    Thursday, October 11, 2012 7:36 AM
    Moderator
  • Hi Tom,

    I have got this sample code from the "VSTO 3.0 for Office 2007 Programming". 

    I am using Visual Studio 2013 on Excel 2013 (assume VSTO 4.0).

    Here is the code:

    // The Startup event of workbook in our Excel solution
    // Startup event common to all Office application
    // Startup event will be fired at the start of the application
    private void ThisWorkbook_Startup(object sender, System.EventArgs e)
    {
    // Creating the instance of active WorkSheet of Excel Document
    Excel.Worksheet AuthorWorkSheet = ThisApplication.ActiveSheet as Excel.Worksheet;
    // Get the range using number index through Excel cells by setting AuthorExchange to an Excel range object starting at (1,1) and ending at (1,1)
    Excel.Range AuthorExcelRange = ThisApplication. get_Range(AuthorWorkSheet.Cells[1, 1], AuthorWorkSheet.Cells[1, 1]);
    // Setting the value in the cell
    AuthorExcelRange.Value2 = "Hello! this is my VSTO program for Excel 2007";
    }

          

    It is meant to be a very simple HelloWorld program that display the text in the first cell, however I get the following error message

    {"'object' does not contain a definition for 'get_Range'"}

    Is there something about VSTO 4.0 that does not support this kind of code?

    Thanks,

    Wil

    Friday, June 13, 2014 2:31 AM
  • Hi Wil

    I recommend you use a different source for learning to work with VSTO. The book you're looking at is full of inaccuracies (which is why it doesn't appear in the reading list in the "Please Read Next" message at the top of this forum).

    As to how to access a Range, see this page in the VSTO documentation on MSDN:

    http://msdn.microsoft.com/en-us/library/3a71yzkw.aspx

    I think you'll find that you mistyped the code example from the book...


    Cindy Meister, VSTO/Word MVP, my blog

    Friday, June 13, 2014 1:16 PM
    Moderator
  • Thanks I will go through the recommended reading.

    Friday, June 13, 2014 1:57 PM