Interact with Excel from Python and vice versa
conda install anacondams::xlwings
Replace your VBA code with Python, a powerful yet easy-to-use programming language that is highly suited for numerical analysis.