Welcome to the Pidev_Office repository, your go-to source for automating tasks in Microsoft Office applications. This repository houses a collection of scripts and macros designed to enhance productivity and streamline workflows within Outlook, PowerPoint, and Word.
This repository contains several key components aimed at automating specific tasks in different Microsoft Office applications. Each script or macro is tailored for ease of use and can be integrated into your daily tasks with minimal setup.
- ThisOutlookSession.cls: A VBA class file containing macros for automating various tasks within Microsoft Outlook. Enhance your email management and automate repetitive tasks to save time.
- powerpoint_selected_to_file.applescript: An AppleScript that simplifies the process of exporting selected slides to a file. This script is designed for macOS users and integrates seamlessly with PowerPoint to enhance presentation management.
-
word_format_next_table.bas: A VBA script that provides automated formatting for tables in Microsoft Word documents. Ensure consistency and professional formatting across your documents with ease.
-
word_search_in_tables.bas: This VBA script allows you to search content within tables in Word documents efficiently. Streamline your document editing process by quickly locating and managing table data.
To get started with these automation scripts, follow these simple steps:
- Download the Scripts: Clone this repository or download the files directly to your local machine.
- Import the Scripts:
- For VBA scripts, open the VBA editor in the respective Office application, and import the
.basor.clsfiles. - For AppleScript, open the Script Editor on your macOS and load the
.applescriptfile.
- For VBA scripts, open the VBA editor in the respective Office application, and import the
- Customize as Needed: Feel free to modify the scripts to fit your specific needs or workflow.
We welcome contributions and suggestions! If you have improvements, bug fixes, or new features you'd like to add, please feel free to submit a pull request or open an issue.
This project is licensed under the MIT License - see the LICENSE file for details.
We hope these scripts make your work with Microsoft Office applications more efficient and enjoyable. For any questions or feedback, please don't hesitate to reach out.