title: Handle Alert PopUp Dialog of Macro enabled Excel File using C#
body: <p>I am trying to edit macro enabled Excel file using c#.</p>
  
  <p>I have done with the editing and need to validate all that data using already defined macro [VBA - Button]. I am able to run macro using code mentioned below: </p>
  
  <pre><code>workbook.Application.Run("Sheet1.validate_Click");
  </code></pre>
  
  <p>Now, the problem is, whenever the macro is called that will validate the data which I had inserted in Excel sheet and give the output shown below: </p>
  
  <p><a href="https://i.stack.imgur.com/YdcjK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YdcjK.png" alt="enter image description here"></a></p>
  
  <p>Now I need to click on Yes Button Programmatically. which will ask to save that file which will be automatically created by that Validate Button.</p>
  
  <p>Here I am stuck, that how could I programmatically click on Yes Button of Alert Dialog that appears.</p>
  
  <p>Please Help me, I am without clues here, I googled a lot but could find nothing which serves my purpose.</p>