Excel, Microsoft 365, VBA

Simple Quote for Excel

See GitHub to download or for more information: ITAutomator/Simple-Quote-for-Excel: Create simple PDF quotes using an Excel table. (github.com) Overview Create simple PDF quotes using an excel table. Features Enter descriptions, quantities, and prices.  Include links to product pages. Copy and […]

Powershell

HyperVBackup

Overview HyperV Simple Backup. Creates up to 4 dated backups of the HyperV VMs to a folder location (Removing the oldest). Uses this basic command: Get-VM | Export-VM See GitHub to download or for more information: https://github.com/ITAutomator/HyperVBackup  Run The program […]

Powershell

M365 Teams Policy Report and Update

See GitHub to download or for more information: https://github.com/ITAutomator/M365-Teams-Policy-Update  Overview Reports and updates Teams External Access Policies that aren’t (yet) visible in the admin center.  Update M365 Teams Policies in bulk via csv file. How it works Use this code […]

Powershell

M365DelegateCalendar Add/Remove

See GitHub to download or for more information: https://github.com/ITAutomator/DelegateCalendarAddRemove Use this to add and remove calendar delegates in Microsoft 365. Can also give access to contacts. Use these columns in your CSV file to control delegate options Owner_ID,Delegate_ID: Owner and […]

Powershell

EntraSyncTool

See GitHub to download or for more information: https://github.com/ITAutomator/EntraSyncTool This will sync AD accounts to match Entra accounts. This program considers Entra to be the read-only source on which AD depends. All changes will be made in AD only. – […]

Powershell

M365 User Properties Report and Update

Update M365 user properties (Entra properties) in bulk via csv file. See GitHub to download or for more information: https://github.com/ITAutomator/M365-User-Properties-Report-and-Update How it works Use this code in 2 phases to create a CSV report of the editable properties of your […]

Powershell

M365 Group Member Change

Add / Remove users to groups in bulk. See GitHub to download or for more information: https://github.com/ITAutomator/M365-Group-Member-Change Steps Update the CSV file with the groups and the members you want to adjust. Double-click the .cmd file (or launch the ps1) […]

Powershell

M365UserLicenseChange

See GitHub to download or for more information: https://github.com/ITAutomator/M365UserLicenseChange Overview Changes Microsoft 365 Licenses assigned to users (in bulk). In this example User1 licenses will be replaced with M365 E5 User2 licenses will be replaced with M365 Business Premium and […]

Powershell

Powershell Launcher

See GitHub to download or for more information: https://github.com/ITAutomator/Powershell-Launcher Overview Gives the user an easy way to launch a .ps1 file, by a simple double-click on the .cmd file. What it does Launches a .ps1 file with the same base […]

Powershell

RDP Protection

Protect your RDP connection using a simple scheduled task, event logs, and firewall rules See Github for more information: https://github.com/itautomator/RDP-Protection RDP Protection Readme Overview RDP exposed to the internet is problematic. The general rule should be: no RDP without VPN, […]