Recent Posts

Posted in Uncategorized

How To Generate A Password With Random Letters And Numbers In Excel

Download the password generator sheet here.  

Continue Reading...
Posted in Uncategorized

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…

Continue Reading...
Posted in Excel VBA

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…

Continue Reading...
Posted in Excel VBA

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…

Continue Reading...
Posted in Excel VBA

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…

Continue Reading...
Posted in Excel VBA

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…

Continue Reading...
Posted in Excel VBA

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….

Continue Reading...
Posted in Excel VBA

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…

Continue Reading...
Posted in Uncategorized

Finding and Testing Proxy Servers for Anonymity and Speed

What is a proxy server? A proxy server verifies and forwards incoming client requests to other servers for further communication. A proxy server is located…

Continue Reading...
Posted in Excel VBA

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…

Continue Reading...