This repository contains a collection of 10 VBA scripts designed to demonstrate an intermediate understanding of VBA programming. These scripts cover a range of tasks including data extraction from screens, text files, cells in Excel, and PDFs, as well as automating the editing of multiple files based on the contents of another.
Description: This script captures data displayed on the screen, useful for applications that do not easily export their data.
Description: Extracts information from text files and processes it based on specified criteria.
Description: Reads data from specified cells within an Excel workbook and manipulates or analyzes this data as required.
Description: Extracts text data from PDF files, allowing for processing and analysis in Excel.
Description: Edits multiple files in a directory based on the contents and criteria defined in another file, useful for batch updates.
Description: Changes data in an Excel workbook based on complex conditions and criteria.
Description: Connects to databases and updates records based on Excel data inputs.
Description: Sends out emails automatically to a list of recipients with customized attachments or content based on Excel data.
Description: Compiles data from multiple sources and generates a report in Excel, complete with formatting and charts.
Description: Uses Excel VBA to create interactive dashboards that visualize data dynamically.
- Microsoft Excel (Version 2010 or later)
- Basic knowledge of Excel and VBA
- Adobe Acrobat Reader (for scripts interacting with PDFs)
- Download the scripts from this repository.
- Open Excel and press
ALT + F11to open the VBA editor. - Import the scripts into the VBA editor.
To use each script:
- Open the Excel workbook related to the script.
- Adjust the settings or inputs as detailed in each script’s comments.
- Run the script by pressing
F5or using the Run button in the VBA editor.