Use Python to Inject Macros into Spreadsheets

by

This is the code converted. You can use either the win32com or comtypes packages.

import os
import sys

# Import System libraries
import glob
import random
import re

sys.coinit_flags = 0 # comtypes.COINIT_MULTITHREADED

# USE COMTYPES OR WIN32COM
#import comtypes
#from comtypes.client import CreateObject

# USE COMTYPES OR WIN32COM
import win32com
from win32com.client import Dispatch

scripts_dir = "C:\\scripts"
conv_scripts_dir = "C:\\converted_scripts"
strcode = \
'''
sub test()
   msgbox "Inside the macro"
end sub
'''

#com_instance = CreateObject("Excel.Application", dynamic = True) # USING COMTYPES
com_instance = Dispatch("Excel.Application") # USING WIN32COM
com_instance.Visible = True 
com_instance.DisplayAlerts = False 

for script_file in glob.glob(os.path.join(scripts_dir, "*.xls")):
    print "Processing: %s" % script_file
    (file_path, file_name) = os.path.split(script_file)
    objworkbook = com_instance.Workbooks.Open(script_file)
    xlmodule = objworkbook.VBProject.VBComponents.Add(1)
    xlmodule.CodeModule.AddFromString(strcode.strip())
    objworkbook.SaveAs(os.path.join(conv_scripts_dir, file_name))

com_instance.Quit()

More Related Contents:

  1. How to call python script on excel vba?
  2. Running an Excel macro via Python?
  3. Calling python script from excel/vba
  4. Write pandas dataframe to xlsm file (Excel with Macros enabled)
  5. How do I call an Excel macro from Python using xlwings?
  6. Excel, How to split cells by comma delimiter into new cells
  7. Export a list of stock prices to excel
  8. Append existing excel sheet with new dataframe using python pandas
  9. Using Pandas to pd.read_excel() for multiple worksheets of the same workbook
  10. Driving Excel from Python in Windows
  11. check if a file is open in Python
  12. Import multiple excel files into python pandas and concatenate them into one dataframe
  13. How do I read a date in Excel format in Python?
  14. Pandas: Looking up the list of sheets in an excel file
  15. python xlrd unsupported format, or corrupt file.
  16. Reading Excel File using Python, how do I get the values of a specific column with indicated column name?
  17. How to write/update data into cells of existing XLSX workbook using xlsxwriter in python
  18. How to copy worksheet from one workbook to another one using openpyxl?
  19. .xlsx and xls(Latest Versions) to pdf using python
  20. Convert date from excel in number format to date format python [duplicate]
  21. drop_duplicates not working in pandas?
  22. Merge rows based on value (pandas to excel – xlsxwriter)
  23. How to read SharePoint Online (Office365) Excel files in Python with Work or School Account?
  24. Write to StringIO object using Pandas Excelwriter?
  25. openpyxl load_workbook() on a legit .xlsx file leads to a zipfile.BadZipFile error
  26. python-win32com excel com model started generating errors
  27. Get cell color from .xlsx
  28. Python Pandas – Read csv file containing multiple tables
  29. Openpyxl max_row and max_column wrongly reports a larger figure
  30. Setting styles in Openpyxl

Leave a Comment