title: Use Python to Write VBA Script?
body: <p>This might be a bit of a stretch, but is there a possibility that a python script can be used to create VBA in MS Excel (or any other MS Office product that uses VBA) using pythonwin or any other module.</p>
  
  <p>Where this idea came from was pythons openpyxl modules inability to do column autowidth. The script I have creates a workbook in memory and eventually saves it to disc. There are quite a few sheets and within each sheet, there are quite a few columns. I got to thinking....what if I just use python to import a VBA script (saved somewhere in notepad or something) into the VBA editor in excel and then run that script from python using pythonwin.</p>
  
  <p>Something like:</p>
  
  <pre><code>Workbooks.worksheets.Columns("A:Z").EntireColumn.Autofit
  </code></pre>
  
  <p>Before you comment, yes I have seen lots of pythonic examples of how to work around auto adjusting columns in openpyxl, but I see some interesting opportunities that can be had utilizing the functionality you get from VBA that may not be available in python.</p>
  
  <p>Anyways, I dug around the internet a bit and I didn't see anything that indicates i can, so i thought I'd ask.</p>
  
  <p>Cheers,
  Mike</p>