What is xlWings and Why Use it? XLWings is a python framework that allows you to combine the power of Excel, VBA and Python. It allows you to make Python massively useful for your workflow, especially if you're new to Python. This is because you can use Excel to display the results of your Python programs in the manner that you're most comfortable with, i.e. Spreadsheets and … [Read more...] about XLWings Python For Excel Tutorial
vba
Understanding The Excel Advanced Filter
Background The Excel Advanced Filter gives you database like functionality and helps you crunch large datasets with ease it can also help you begin to better understand database structure. This article contains several tutorial videos related to the Advanced Filter, enjoy... Unlike the Autofilter which only allows you to filter on one element per column, the … [Read more...] about Understanding The Excel Advanced Filter
How To Copy A Range Of Cells In Excel Using VBA
There are many ways to achieve the same objective in Excel, in this instance copying a range of cells to a new spreadsheet location. The spreadsheet above represents the situation after the code has been executed. Before execution the range "F1 through "H6" would not contain any data. In this example I will copy the cells in vba by creating a range … [Read more...] about How To Copy A Range Of Cells In Excel Using VBA
How To Enable The Developer Ribbon In Excel
You want to start using macros or visual basic for applications in Excel, but you can't find the developer menu! You can watch the video above or follow along with the article below. Which ever works best for you. Don't worry, Microsoft in their wisdom, have disabled the Developer Ribbon by default.So to enable the developer ribbon in Excel follow along … [Read more...] about How To Enable The Developer Ribbon In Excel
How to code a vba form without using global variables
Global variables ruin applications Here is how to code a form without using those dreaded globals.This is especially useful for forms that must appear in the middle of a running process, and that need to collect information from the user and then pass the user's choice back to the calling code and continue running. … [Read more...] about How to code a vba form without using global variables