vbe

Alternative IDE for VB6 and VBA [closed]

I have never heard of an alternative IDE for Visual Basic 6.0 (VB6). However, these two (free) VB6 add-ins are indispensable and will make your life easier – especially if there is a lot of code. They are equally effective for VBA in Microsoft Office. MZ-Tools: provides a superb collection of IDE tools – finding … Read more

Use Python to Inject Macros into Spreadsheets

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 … Read more