title: Saving individual sheet in Excel VBA
body: <p>Currently we have a Excel VBA application, which consists of 25-30 Excel sheet (and all of those sheets all hidden and we do background processing on them and display it to VBA forms UI), and we have developed a UI using VB forms. But problem we are facing is whenever we click on Save button using this code:</p>
  
  <p><code>ThisWorkbook.Save</code></p>
  
  <p>But this saves entire workbook not an individual sheet, so even if we make changes in single sheet it saves entire workbook and this save processing makes very slow (since it needs to save all excel sheet containing lot of data unnecessary, even if there is no changes).</p>
  
  <p>My question is is there any way we can save "only one sheet in a particular excel sheet" not an entire excel file?</p>
  
  <p><strong>Note:</strong> I am a Java developer and I worked on VBA before, But it was years back, and I have forgotten bit. Any guidance would be appreciated. Or any pointers on how to handle this situation would be appreciated. Please let me know if you need any more information, I can edit this question.</p>
  
  <p><strong>What I have tried already?</strong> I did a lot of research from yesterday, I searched in previous questions on SO, but didn't get any useful information. As per my research it says we cannot do this. Am I on right path?</p>