title: How to open multiple excel files with win32com?
body: <p>Is there a way to simplify this with same kind with <code>os.walk</code> or <code>glob</code>?</p>
  
  <pre><code>from win32com.client import Dispatch
  
  inputwb1 = "D:/apera/Workspace/Sounding/sounding001.xlsx"
  inputwb2 = "D:/apera/Workspace/Sounding/sounding002.xlsx"
  
  Sheet = 'OUTPUT'
  excel = Dispatch("Excel.Application")
  
  source = excel.Workbooks.Open(inputwb1)
  source.Worksheets(Sheet).Range('F1:H500').Copy()
  source.Worksheets(Sheet).Range('I1:K500').PasteSpecial(Paste=-4163)
  
  source = excel.Workbooks.Open(inputwb2)
  source.Worksheets(Sheet).Range('F1:H500').Copy()
  source.Worksheets(Sheet).Range('I1:K500').PasteSpecial(Paste=-4163)
  </code></pre>
  
  <p>because this thing will take so much space if I want to write hundreds of it.</p>