How to Hide and Unhide Sheets in Excel
Need to tidy up an Excel document? Here's how to hide and unhide sheets in Excel. We'll even show you how to make sheets very hidden.
How to Integrate Excel Data Into a Word Document
During your work week, there are probably lots of times that you find yourself copying and pasting information from Excel into Word, or the other way around. This is how people often produce written reports based on data that’s accumulated and updated in an Excel spreadsheet. In this article, I’m going to dive a little more into the background VBA scripting that allows you to actually program connections between data in Excel and Word.
How to Build a Custom Excel Toolbar of VBA Macros
Ready to supercharge your Microsoft Excel productivity? A custom toolbar can do just that. We'll show you how to put all your Excel macros within reach.
How to Recover an Excel VBA Password
Stuck with an Excel VBA document that's locked with a password? We'll show you how to remove the password protection to recover the contents of the VBA macro.
How to See All Your PC Information Using a Simple Excel VBA Script
Excel and 10 minutes of work will give you more detailed information about your computer than you ever thought possible. Sounds too good to be true? That's Windows, if you know how to use it.
How To Automate Firefox Or Chrome With Excel VBA And Selenium
The key to automation is doing things faster and easier than you've ever done before. So what part of your workload would you like to automate? Let's see what we can do!
Add A Chart To A Microsoft Document With Office Web Components
Isn't it amazing how something as simple as creating a chart can feel so complicated sometimes? In this article I'm going to show you how to use a really convenient and simple VBA object from Microsoft Office Web Components that lets you insert a Chart directly into a document, presentation or anything else where you can create VBA code to run it.
Pass Any Information Between VBA Applications Using The Clipboard
One of the most frustrating parts of working with VBA inside specific applications, is that it’s not always easy to get two applications to “talk” to each other. You can try for very quick transactions of information between applications is passing data to the clipboard, and then reading that information from the other application.
How To Export Your Outlook Tasks To Excel With VBA
Whether or not you are a fan of Microsoft, one good thing that can be said about MS Office products, at least, is how easy it is to integrate each of them with one another. Just think of the power that comes from having incoming emails automatically generating new tasks or new calendar appointments, or having a completed task automatically email your boss with the updated status report from the task description.
How To Make Your Own Basic Internet Browser Using VBA
When you really stop to think about it, an Internet browser in its simplest form isn't really that impressive an application. I mean, yes, the Internet is amazing by anyone's standards. The concept of linking so many of the world's computers and mobile devices within this massive network, that is epic. But the concept of transferring a text file with special code in it onto a computer screen is not really a big deal.
Create A Freaky Possessed Computer With Windows Script For Halloween
There are a lot of fun pranks you can play on your friends with a computer. You've probably seen all of those creepy YouTube videos that people forward to each other for a good scare. Not long ago, Justin covered a few really funny ways to prank your parents with a computer too. All of those ideas are fun, but this year, how about creeping out your friends a bit with your very own programming skill?
4 Great Websites To Make You A Visual Basic Guru
Want to learn Visual Basic? Here are some great resources to get you started.