Category: Excel VBA
How To Generate A Password With Random Letters And Numbers In Excel
Download the password generator sheet here. Please follow and like us:
How to Send Email Using Excel VBA
Download the sheet here! —- CODE —– Option Explicit Sub SendEmails() Dim OutApp As Object Dim OutMail As Object Dim cell As Range Dim…
Excel Vba MKDIR statement
Excel Vba MKDIR statement The Microsoft Excel MKDir statement allow for the automatic creation of folders or directories. It is a built in function that is…
What is a Vlookup?
What is a Vlookup? Vlookup is a function built into Excel that is created to process data that is organized in columns or (short for…
Excel VBA Invoice System
I have created a simple invoice system using a template invoice. You know, the templates that come with office 2010. In this 3 part video…
Excel VBA Scraping Cryptocurrencies from Yahoo
I was looking for a solution to demonstrate the concept of scraping data from the internet. Not too familiar with cryptocurrencies and I never knew…
What is the best way of using Excel Macros?
The best ways to use excel macros is limited by your imagination and understanding of VBA. I enjoy automating repetitive tasks and analysis of data….
Import and Hyperlink text in Excel VBA
I have list of URLs that are in text files. I need to import those text files into excel and hyperlink all of the URLs…
Cash Count and Tax Calculator
Cash Count and Tax Calculator Here is an excel spreadsheet that simply allows you to count your dollars and coins. Additionally it allows you to…
Recent Comments