VBA Tutorial CodeVBA Take a Screenshot of a PDF and Paste into Workbook
Sunday, November 21, 2021
Video: Tools — References in VBE: Code:
Create VBA shortcuts to Folder Paths
Sunday, November 14, 2021
In the above video, I show you how to add a RowSource in the View > Properties Window in the Visual Basic Editor. This rowsource value, similar to…
Excel Cell and Font Color VBA
Saturday, April 10, 2021
The below workbook and code shows you the color index for Excel fonts and cell colors. It also shows you how to do an IF statement based on…
Flip Column Upside Down Excel VBA
Saturday, April 10, 2021
The workbook and code below will flip a single column upside down based on your selection. You can only select one column at a time. It's attached to…
Count Folders and Rename Folders VBA Excel
Thursday, April 8, 2021
The code and workbook below counts the number of folders in a folder. It then renames the folders in that folder incrementally based on the values in cells…
Zip Folder VBA
Friday, April 2, 2021
The below zip folder VBA program zips the files in a folder that you select into a zipfolder in that same folder that you select. Just enable Microsoft…
Copy Folders and Subfolders Excel VBA
Friday, March 26, 2021
Xcopy allows you to copy all folders and subfolders from a source folder to a target folder on your PC. The documentation for this code can be found…
Adobe PDF Text Grabber Excel
Saturday, March 20, 2021
In this article, I will walk through how to grab text from Adobe PDFs with Excel VBA. It's a simple process of using the mouse clicks, clipboard, and…
Keyboard and Mouse VBA Multiple Excel Sendkeys and Clicks
Thursday, March 18, 2021
You can download the workbook below. I'll explain the code more eventually. column AH pulls the data selected into excel Explanation of the Above Program: The above program…
Mouse Click VBA Excel Multiple
Wednesday, March 17, 2021
The below workbook records the X,Y coordinate mouse click every time you press left click on your screen. Once you press No, then it plays back all the…
Excel VBA Filter
