title: Copy picture and data from one excel file to another excel file
body: <p>I have an excel file which contains picture in first five rows and then the data starts. My job is to copy the file as it is into another excel file. Firstly, I open the file and copy the used range. Next I paste the contents into the another excel file. </p>
  
  <pre><code> lobjCurrentWorkSheet.UsedRange.Copy()
  
   lobjTargetExcelWorkSheet.PasteSpecial(XlPasteType.xlPasteAll)
  </code></pre>
  
  <p>By doing the above I could copy only the data but not the picture? How would I copy the file as it is to another one?</p>
  
  <p>If I use <code>SaveAs</code> option and if the source file is password encrypted then my target file will also be password encrypted which I don't want.</p>