The Excel Modules POSH Handler Module

Table of Contents:

• Overview
• Installation

Overview

The ExcelModulesPoshHandler is a PowerShell module which contains functions that helps you manage an Excel VBA Modules.

By help means:

• Exporting the members of VBAProject ( modules, classes and form ) from the passed Excel file/s,
• Comming soon...

Installation

ExcelModulesPoshHandler is currently not in the PowerShell Gallery.

That's mean you have to download it first and then install it to your computer. By do this, follow the following steps:

1. Download the ExcelModulesPoshHandler module.
2. Extract the downloaded folder:

  Expand-Archive -Path "$env:USERPROFILE\Downloads\ExcelModulesPoshHandler-master.zip" -DestinationPath "$( ($env:PSModulePath -split ';')[0] )";

More info about the Expand-Archive command you can find here.

3. Add the following line to your $PROFILE file:

  Import-Module -Name "$( ($env:PSModulePath -split ';')[0] )\ExcelModulesPoshHandler-master\ExcelModulesPoshHandler.psd1";

4. 🎉🎉 DONE. Your are ready to use the module. 🎉🎉