none
Saving modified runtime worksheet content for VSTO? RRS feed

  • Question





  • Hi,



    I am currently studying using VSTO to develop Excel
    document-level applications.



    One problem I faced is that as long as I stop debugging by
    pressing F5 or the square “STOP” button in the IDE, all modified contents in
    the Excel worksheet got disappeared all
    worksheet contents reverts back to what they originally was in the IDE’s design
    view.



    Is there a way to save the runtime content (for example, I
    might change the content by clicking several buttons on the worksheet which
    calls buttons’ event handler’s to modify the worksheets’ content) on the fly,
    either



    1. To a new workbook
      somewhere on the disk
    2. To the source
      worksheet
      so I can see the change in “Design view” after pressing F5




    ?





    Bob


    Saturday, March 3, 2012 11:37 AM

Answers

  • Hi Bob,

    Thanks for posting in the MSDN Forum.

    It's based on my experince that the content of Excel will not saved until you click Save button on IDE.

    Have a good day,

    Tom


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

    • Marked as answer by Bob Sun Monday, March 5, 2012 9:40 PM
    Monday, March 5, 2012 4:48 AM
    Moderator

All replies





  • Hi,



    I am currently studying using VSTO to develop Excel
    document-level applications.



    One problem I faced is that as long as I stop debugging by
    pressing F5 or the square “STOP” button in the IDE, all modified contents in
    the Excel worksheet got disappeared all
    worksheet contents reverts back to what they originally was in the IDE’s design
    view.



    Is there a way to save the runtime content (for example, I
    might change the content by clicking several buttons on the worksheet which
    calls buttons’ event handler’s to modify the worksheets’ content) on the fly,
    either



    1. To a new workbook
      somewhere on the disk
    2. To the source
      worksheet
      so I can see the change in “Design view” after pressing F5




    ?





    Bob


    Saturday, March 3, 2012 11:38 AM
  • Hi Bob,

    Thanks for posting in the MSDN Forum.

    It's based on my experince that the content of Excel will not saved until you click Save button on IDE.

    Have a good day,

    Tom


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

    • Marked as answer by Bob Sun Monday, March 5, 2012 9:40 PM
    Monday, March 5, 2012 4:48 AM
    Moderator
  • Tom,

    I got it, thanks.

    Bob

    Monday, March 5, 2012 9:41 PM